Why does this query return 0?
What is the maximum length of an extended property?
What are the constraints on severity level in raiseerror?
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?
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?
Explain about the hierarchical model of the database?
What is the database development process?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What are the main phases of database development?
How to replace not in with not exist?
Define candidate key, alternate key, composite key?
30 Answers IAS, IBM,
What are cursors? Explain different types of cursors?
What is database design and development?