98-364 question 71 discussion

answered

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.
Created 1 month, 1 week ago by icter

mtblessing

The answer is D, its worth having a look at this link to understand how transactions are processed in T-SQL https://msdn.microsoft.com/en-us/library/aa480356.aspx