Sql Interview QUESTIONS AND ANSWERS :: part8 : 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.What will be the output of a query given below? SELECT person_id, fname, lname FROM person WHERE person_id=1; |
| Show only columns(person_id, fname, lname) but only those rows which belongs to person_id=1 |
| Show all columns and rows |
| Shows only columns person_id |
| None of these |
7.Which of the following clause is evaluated in the last by database server? |
| SELECT |
| WHERE |
| FROM |
| None of these |
8.What will be the output of the query given below? #107. What will be the output of the query given below? SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’ AND start_date>2008-11-23; |
| 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” and start_date>2008-11-23 |
| None of the above |
9.Find the error? SELECT *; |
| No Error |
| No table mentioned |
| Depends |
| None of these |
10.What is the meaning of “SELECT” clause in Mysql? |
| Show me all Columns and rows. |
| Show me all columns. |
| Show me all rows. |
| None of these |
More Sql Interview QUESTIONS AND ANSWERS available in next pages
-
Health is the greatest gift, contentment is the greatest wealth -Buddha
- 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
If your ship doesnât come in, swim out to meet it!-Jonathan Winters
