Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part7 : 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.What will be the output of the query given below? SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’;

All columns

Only those columns which are mention with “SELECT” clause

Columns mention with “SELECT” clause and only those rows which contain ‘HEAD TELLER’ as a “title”

None of the above

12.“MODIFY” is used with which “Query clause”?

ALTER

FROM

WHERE

ORDER BY

13.Which clause is used to “filter out unwanted Groups”?

HAVING

FROM

WHERE

SELECT

14.Which clause is used to “Modify the existing field of the table”?

ALTER

FROM

SELECT

MODIFY

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