Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part10 : 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 among the following is the correct syntax for defining “Constraint Check” in Mysql?

gender char(1) check( gender IN (‘M’, ‘F’)),

gender char (1) check,

gender char (1) check ( gender ),

none of these

12.Point out the wrong statement :

RANK() returns the rank of each row in the result set of partitioned column.

DENSE_RANK() is same as RANK() function. Only difference is returns rank without gaps.

NTILE() distributes the columns in an ordered partition into a specified number of groups.

ROW_NUMBER() returns the serial number of the row order by specified column.

13.Which of the the function provides consecutive numbering except in the case of a tie ?

RANK

NTILE

ROW_NUMBER

None of the mentioned

14.Which command is used for the table definition in Mysql?

DESC table_name;

DESC table_name

DESC

None of these

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

Related Online Test