How can I detect whether a given connection is blocked?
What are the types of database model?
In which database can extended stored procedures be added?
What is normalization? Explain different levels of normalization?
8 Answers CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,
Define candidate key, alternate key, composite key?
30 Answers IAS, IBM,
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?
Explain the family trees and connection by clause.
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?
What are the three basic rules which are to be followed for the relational model of the database?
what is the use of foreginkey
What are the constraints on severity level in raiseerror?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What are cursors? Explain different types of cursors?