Microsoft
98-364 · Question #155
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?
The correct answer is D. No rows will be deleted from the table. See the full explanation below for the reasoning.
Question
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?
Options
- AThe table will be corrupted.
- BForty (40) rows will be deleted from the table.
- CThe transaction will restart.
- DNo rows will be deleted from the table.
How the community answered
(48 responses)- A4% (2)
- B2% (1)
- C13% (6)
- D81% (39)
Community Discussion
No community discussion yet for this question.