Sql Interview Questions and Answers

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

Opportunity is missed by most people because it is dressed in overalls and looks like work.- Thomas Edison

Related Online Test