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

Post New Answer

More DB Development Interview Questions

Explain about the relational database?

0 Answers  


How to use timestamp datatypes

0 Answers  


You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  


Explain the role of indexing in databases?

0 Answers  


How to read and create .LDC data files which are used by linguatic dictionary.

0 Answers  


How would you design a database for an online site, which would average a million hits a day?

0 Answers  


what is Normalization?

6 Answers   TCS,


What are the main phases of database development?

0 Answers  


Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

0 Answers   TCS,


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?

0 Answers  


Explain about network model?

0 Answers  


What are the types of database model?

0 Answers  


Categories