Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part4 : 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.With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName” ?

SELECT * FROM Persons SORT BY ‘FirstName’ DESC

SELECT * FROM Persons ORDER FirstName DESC

SELECT * FROM Persons SORT ‘FirstName’ DESC

SELECT * FROM Persons ORDER BY FirstName DESC

7.If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default

ASC

DESC

There is no default value

None of the mentioned

8.________________ is not a category of SQL command.

TCL

SCL

DCL

DDL

9.Which SQL statement is used to return only different values ?

SELECT DIFFERENT

SELECT UNIQUE

SELECT DISTINCT

SELECT ALL

10.Which of the following statement is true ?

DELETE does not free the space containing the table and TRUNCATE free the space containing the table.

Both DELETE and TRUNCATE free the space containing the table.

Both DELETE and TRUNCATE does not free the space containing the table.

DELETE free the space containing the table and TRUNCATE does not free the space containing the table.

More Sql Interview QUESTIONS AND ANSWERS available in next pages

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

If you are not willing to risk the usual you will have to settle for the ordinary- Jim Rohn

Related Online Test