Sql Interview Questions & Answers: part3



Sql Interview QUESTIONS AND ANSWERS :: part3 : 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.Which SQL keyword is used to retrieve a maximum value ?

MOST
TOP
MAX
UPPER

2.Which SQL function is used to count the number of rows in a SQL query ?

COUNT()
NUMBER()
SUM()
COUNT(*)

3.In the following query how many rows will be updated? UPDATE person SET lname=’s’, Fname=’p’, WHERE person_id<10; /* person_id is a primary key */

0-9
1-6
No row
None of these

4.Which of the following SQL clauses is used to DELETE tuples from a database table ?

DELETE
REMOVE
DROP
CLEAR

5.In the following query how many rows will be updated? UPDATE person SET lname=’s’, Fname = ’p’, WHERE person_id = 1; /* person_id is a primary key */

Single row
Double row
No row
None of these

More Sql Interview QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
Identify your problems but give your power and energy to solutions- Tony Robbins