![]() Related Questions Have you eveer encountered an error called "depth not equal"? (This occurs when you extensively create graphs it is a trick question) Latest Answer : Recompile is useful when the tables referenced by the stored proc undergoes a lot of modification/deletion/addition of data. Due to the heavy modification activity the execute plan becomes outdated and hence the stored proc performance goes down. If we ... Latest Answer : The below SQL Query can solve the purpose:select username from V$SESSION; ... Latest Answer : DBCC is stand for database consistency checker. ... When using multiple DML statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why. What is the t-sql command element you would use to place a logical object (table or index) on a specific physical file (file group). Latest Answer : When you use truncate all the space alloted for the records along with records gets deleted and if you use delete only the records are deleted and the space allocated for the records remains unaltered. ... Latest Answer : Lookup is basically a specific dataset which is keyed. This can be used to mapping values as per the data present in a particular file (serial/multi file). The dataset can be static as well dynamic ( in case the lookup file is being generated in previous ... Latest Answer : try "m_db test myfile.dbc" ... Read Answers (1) | Asked by : Gour Latest Answer : Hi ,You can test a dbc file from unix command prompt using m_db test which tests the data base connection, data base version, user name, password, database objects and other required mandatory values checking. Here, ... Read Answers (2) | Asked by : Gour
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||