Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part7 : 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.What will be the output of the query given below? SELECT * FROM employee WHERE (title=’HEAD TELLER’) OR (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” or 2013-01-24 as a “start_date)

Both a and b

None of the above

2.What is the meaning of the “WHERE” clause in Mysql?

Filtering out unwanted rows from result set

Filtering out unwanted columns from result set

Both a and b

None of these

3.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 start_date are greater than 2013-01-24

Both a and b

None of the above

4.What will be the output of the query given below? SELECT * FROM employee WHERE (title=’HEAD TELLER’) OR (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” OR start_date are greater than 2013-01-24

Both a and b

None of the above

5.Which clause is used to “group rows together by common columns values”?

SELECT

GROUP BY

FROM

WHERE

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