You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
724What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
793On 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?
762Post New DB Development Questions
Explain about normal forms?
How to customize error conditions.
Explain about query and reporting.
Explain about xml databases?
What are the constraints on severity level in raiseerror?
Explain about the relational database?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
How to use online Backups?
What is the physical representation for a many-to-many relationship?
What is normalization? Explain different levels of normalization?
Which four data types cannot be used as a return type from a user-defined function?
Who are naive users?
What are data modelling techniques?
What is dbms explain in brief?
