Sql Interview Questions & Answers: part7



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