Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part9 : 6 to 10

Following SQL Multiple choice objective type questions and answers will help you in many software compnaies written examinations and inteview 2015 :

6.Point out the correct statement :

CHECK constraints enforce domain integrity

UNIQUE constraints enforce the uniqueness of the values in a set of columns

In a UNIQUE constraint, no two rows in the table can have the same value for the columns

All of the mentioned

7.Point out the wrong statement :

Table constraints must be used when more than one column must be included in a constraint

A column constraint is specified as part of a column definition and applies only to that column

A table constraint is declared independently from a column definition and can apply to more than one column in a table.

Primary keys allow for NULL as one of the unique values

8.Which of the following constraint does not enforce uniqueness ?

UNIQUE

Primary key

Foreign key

None of the mentioned

9.Which of the following foreign key constraint specifies that the deletion fails with an error ?

NO ACTION

CASCADE

SET NULL

All of the mentioned

10.Which of the following is not a class of constraint in SQL Server ?

NOT NULL

CHECK

NULL

UNIQUE

More Sql Interview QUESTIONS AND ANSWERS available in next pages

Health is the greatest gift, contentment is the greatest wealth -Buddha

Innovation distinguishes between a leader and a follower.-Steve Jobs

Related Online Test