Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part9 : 1 to 5

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

1.Which of the constraint can be enforced one per table ?

Primary key constraint

Not Null constraint

Foreign Key constraint

Check constraint

2.Let the statement : SELECT column1 FROM myTable; return 10 rows. The statement : SELECT ALL column1 FROM myTable; will return

less than 10 rows

more than 10 rows

exactly 10 rows

None of the Mentioned

3.Which of the following is a foreign key constraint ?

NO ACTION

CASCADE

SET NULL

All of the mentioned

4.Which of the following is illegal?

SELECT SYSDATE – SYSDATE FROM DUAL;

SELECT SYSDATE – (SYSDATE – 2) FROM DUAL;

SELECT SYSDATE – (SYSDATE + 2) FROM DUAL;

None of the Mentioned

5.Purpose of foreign key constraint in SQL Server is :

FOREIGN KEY constraints identify and enforce the relationships between tables.

A foreign key in one table points to a candidate key in another table

You cannot insert a row with a foreign key value, except NULL, if there is no candidate key with that value

None of the mentioned

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