Latest Answer: Listener.ora is the configuration file for the listener, living on theserver. Tnsnames.ora is one of the sqlnet configuration files on the client. ...
Latest Answer: This may be considered as the mapping of the data and data relations into an indefinitely large linear address space. This specifies some or all of the data structures necessary to support the data and data relations declared in the conceptual schema. ...
Latest Answer: As trigger is implicitly fired, u can not commit.Here I m giving one example. Let u wrote a trigger for inserting 100 records,And after that U wrote commit,When the particular event occures,the trigger will fired, At the time of record inserting ...
Latest Answer: Perform is purely based on executionhow we get the result, ie Time , spped etcbutexecute is purely depends on logic of how we had done the design and code,itslike the output for given input for a written logic ...
Latest Answer: A Hash index stores key value pairs based on a pseudo randomizing function called hash functionA B+- Tree is a balanced tree whose leaves contain a sequence of key pointer pairs.- Use a hash index for point queries only. Use a B- Tree if multipoint ...
Latest Answer: When the database is taken in backup mode the checkpoint takes place and the datafile header gets frozenAs the checkpoint takes place the database writer writes all the blocks from database buffer cache to datafiles.The same blocks are also written from ...
Latest Answer: Other than those mentioned above the different indexes are1)ClusteredRequires the date to be sortedwe can create 1 clustered2)Non-Clustereddoesnt require the data to be sortedWe can create 249 non-clustered indexes ...
Latest Answer: Null interfaces act as markers. They just tell the compiler that the objects of this class need to be treated differently. some marker interfaces are : Serializable, Remote, Cloneable ...
Latest Answer: Yes, we can update views. Point to remember is : Primary key of all the tables should be present in the view. IT can be a single table or can be 2 or more tables linked in a view. ...
I need to export data in Mainframe DB2 tables on to my PC as IXF files. Are there any commands I can use from QMF or SPUFI or any other Mainframe source to do this?
View page << Previous 1 2 3 4 [5] 6 7 Next >>
Go Top
