Microsoft Exam Questions

What is the result in the database?

You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails
after only 40 rows are deleted.
What is the result in the database?

A.
The table will be corrupted.

B.
Forty (40) rows will be deleted from the table.

C.
The transaction will restart.

D.
No rows will be deleted from the table.