Sql Interview Questions & Answers: part10



Sql Interview QUESTIONS AND ANSWERS :: part10 : 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 following function is used when you want all tied rows to have the same ranking ?

RANK
NTILE
ROW_NUMBER
None of the mentioned

2.What is the role of “CONSTRAINS” in defining a table in Mysql?

Declaring primary key
Declaring Foreign Key
Restrictions on columns
All of the above

3.Which among the following is the correct syntax for defining “ENUM” in Mysql?

gender ENUM (‘M’, ‘F’),
gender ENUM,
gender ENUM ( ),
None of these

4.Which of the following error message will be displayed if ORDER CLAUSE is not mentioned in ROW NUMBER function ?

“The ranking function “ROW_NUMBER” must have an ORDER BY clause.”
“The ranking function “ROW_NUMBER” must have an OVER BY clause.”
“The ranking function “ROW_NUMBER” must have an PARTITION BY clause.”
All of the mentioned

5.Which of the clause is not mandatory ?

OVER clause
ORDER BY clause
PARTITION BY clause
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
Identify your problems but give your power and energy to solutions- Tony Robbins