Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part7 : 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 not a “query clause”?

WHERE

MODIFY

ALTER

FROM

7.What will be the output of the query given below? SELECT * FROM employee WHERE title=’HEAD TELLER’;

All columns and rows belong to table employee

All columns but only those rows which contain ‘HEAD TELLER’ as a “title”

Both a and b

None of the above

8.Which clause is used to “sort the rows of the final result set by one or more columns”?

HAVING

ORDER BY

WHERE

FROM

9.What will be the output of the query given below? SELECT * FROM employee WHERE (title=’HEAD TELLER’) AND (start_date=2013-01-24);

All columns and rows belong to table employee

All columns but only those rows which contain ‘HEAD TELLER’ as a “title” and 2013-01-24 as a “start_date)

Both a and b

None of the above

10.Which clause is used to “Filters out unwanted data”? #92. Which clause is used to “Filters out unwanted data”?

FROM

WHERE

SELECT

ORDER BY

More Sql Interview QUESTIONS AND ANSWERS available in next pages

Health is the greatest gift, contentment is the greatest wealth -Buddha

Innovation distinguishes between a leader and a follower.-Steve Jobs

Related Online Test