Sql Interview Questions & Answers: part9



Sql Interview QUESTIONS AND ANSWERS :: part9 : 11 to 15

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

11.Which of the following is not a ranking function ?

RANK
NTILE
ROW_NUMBER
All of the mentioned

12.How many types of constraints are present in SQL Server ?

4
5
6
7

13.The SQL statement #122. The SQL statement SELECT SUBSTR(’123456789′, INSTR(‘abcabcabc’, ‘b’), 4) FROM DUAL;

6789
2345
1234
456789

14.Constraints can be applied on :

Column
Table
Field
All of the mentioned

More Sql Interview QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
Too many of us are not living our dreams because we are living our fears.- Les Brown