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.
How To Pass 98-364 Exam?FULL Printable PDF and Software. VALID exam to help you PASS. |
 |
I was thinking of the B option, but I realize the text “TRANSACTION” so the COMMIT TRANSACTION statement is necessary to complete this task.
Saying this, the answer is D, “no rows deleted”.