What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
No Answer is Posted For this Question
Be the First to Post Answer
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What are the key features of dbms?
What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Explain about the database management systems.
Can you have a nested transaction?
Who are naive users?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What are cursors? Explain different types of cursors?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
What are the 18 schemas?
hi in which phase of mload can i use .FILLER