Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part4 : 11 to 15

Following SQL Multiple choice objective type questions and answers will help you in many software compnaies written examinations and inteview 2015 :

11.The UPDATE SQL clause can

update only one row at a time

update more than one row at a time

delete more than one row at a time

delete only one row at a time

12.Which of the following are TCL commands ? #47. Which of the following are TCL commands ?

UPDATE and TRUNCATE

SELECTand INSERT

GRANT and REVOKE.

ROLLBACK and SAVEPOINT.

13.With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a” ?

SELECT * FROM Persons WHERE FirstName=’a’

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

SELECT * FROM Persons WHERE FirstName=’%a%’

14.Which SQL keyword is used to sort the result-set ?

ORDER BY

SORT

ORDER

SORT BY

More Sql Interview QUESTIONS AND ANSWERS available in next pages

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

The only place where success comes before work is in the dictionary.- Vidal Sassoon

Related Online Test