In which database can extended stored procedures be added?
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?
How can you fix a poorly performing query?
What is normalization? Explain different levels of normalization?
8 Answers CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,
Who are naive users?
What is an application role and explain a scenario when you would use one?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
Define candidate key, alternate key, composite key?
30 Answers IAS, IBM,
Write the fastest query to find out how many rows exist in a table?
How to create an external table.
Explain about post-relational databases?
can you give me the syntax of named procedure??
What is dbms explain in brief?