RSS Feed

Multiple Choice Questions on SQL Delete

Multiple Choice Questions on SQL Delete

1. Error handling for the DELETE statement can be implemented by specifying the statement in a TRY…CATCH construct.

A) True
B) False

2. You can use TOP in a DELETE statement against partitioned views.

A) True
B) False

3. The DELETE statement is not logged.

A) True
B) False

4. You can use the Delete statement with multiple tables and JOIN.

A) True
B) False

5. By default, a DELETE statement acquires …………… lock on the table it modifies.

A) CARE
B) NOWAIT
C) Row update
D) Exclusive(x)

6. You can use ………function to return the number of deleted rows to the client application.

A) @@NUM
B) @@ROWNUM
C) @@ROWCOUNT
D) @@COUNT

7. Which of the following is a valid statement:

A) DELETE Table_Name;
B) DELETE FROM Table_Name;
C) Both;
D) None

8. When the DELETE transaction commits, the records still stay, taking up space in the table until ghost cleanup task clears them.

A) True
B) False

9. You can drop a column with the help of DELETE

A) TRUE
B) False

10. With the help of DELETE you can delete rows of the table even if FOREIGN KEY or any other constraint is violated.

A) TRUE
B) False

Answers