![](/web/images/inner-content-top-img.gif)
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
![](/web/images/quick-links.gif)
- TNTET 2021 - Practice
- SSC CGL 2021 - Practice
- TNPSC Group 2A 2021 - Practice
- IIT JEE
- IIT JEE Q&A
- TNPSC Answer Keys
- TNPSC Group 2 Syllabus
-
TNPSC Q&A
- Online Tests - TNPSC
- Online Tests - GK
- IBPS 2020-2021
- Online Tests - Bank
- Online Tests - RRB NTPC
- Online Tests - UGC NET
- Online Tests - TANCET
- Online Aptitude Test
-
Engineering
-
Programming
-
Basic Science
-
Quiz
- Plus Two Question Papers
- SSLC Question Bank
-
Aptitude Tests
-
Logical Reasoning
-
General Knowledge-Hindi
-
Indian History MCQ
-
Indian Geography MCQ
-
Indian Civics MCQ
-
Indian Economics MCQ
-
CTET Biology MCQ
-
CTET Chemistry MCQ
-
CTET Physics Solved MCQ
-
Arithmetic Tests
- Press Release
- FAQ
- Coaching Centres
- TNPSC Group 1 Syllabus
-
TNPSC Group IV Syllabus
- TRB 2017 in English PDF
- TRB 2017 in Tamil PDF
- TET
- TNTET
![](/web/images/news-header.gif)