Sql Interview Questions and Answers

Sql Interview QUESTIONS AND ANSWERS :: part3 : 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.Which of the following statement is true ? #32. 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.

7.In the following query how many rows will be deleted? DELETE person WHERE person_id=1; /*person_id is a primary key */

No row

None of these

8.In the following query how many rows will be deleted? DELETE person WHERE person_id<10; /*person_id is a primary key */

0-9

1-7

No row

None of these

9.Which statement is used to delete an existing row from the table?

DELETE

WHERE

MODIFY

None of these

10.___________removes all rows from a table without logging the individual row deletions.

DELETE

REMOVE

DROP

TRUNCATE

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