Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part8 : 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 a query given below? SELECT * FROM person WHERE person_id=1;

Show all columns but only those rows which belongs to person_id=1

Show all columns and rows

Shows only columns person_id

None of these

2.What is the full form of SQL?

Structured Query Language

Structured Query List

Simple Query Language

None of the Mentioned

3.What will be the output of a query given below? SELECT * FROM person;

Show all rows and columns of table “person”

Show all rows of table “person”

Show all columns of table “person”

None of these

4.Which clause is mandatory with clause “SELECT” in Mysql?

FROM

WHERE

Both a. and b.

None of these

5.In SQL, which command is used to SELECT only one copy of each set of duplicable rows

SELECT DISTINCT

SELECT UNIQUE

SELECT DIFFERENT

All of the Mentioned

More Sql Interview QUESTIONS AND ANSWERS available in next pages

Health is the greatest gift, contentment is the greatest wealth -Buddha

Failure defeats losers, failure inspires winners.-Robert T. Kiyosaki

Related Online Test