Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part10 : 6 to 10

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

6.Which among the following is the correct syntax for creating table?

CREATE TABLE name;

CREATE name;

CREATE TABLE

All of the above

7.Which of the following functions are similar ?

RANK and NTILE

RANK and DENSE_RANK

DENSE_RANK and NTILE

None of the mentioned

8.Which of the following is the simplest ranking function ? #137. Which of the following is the simplest ranking function ?

RANK

NTILE

ROW_NUMBER

None of the mentioned

9.Which of the following will not raise error if not used ?

OVER clause

ORDER BY clause

PARTITION BY clause

All of the mentioned

10.Which data type character merge the “Check Constraint” into a data type definition?

ENUM

ENUM1

ENUM2

None of these

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