Microsoft
98-363 · Question #28
You write code that makes two SQL Server updates inside an ADO.NET transaction. One statement succeeds. The other statement fails. What happens when the transaction is rolled back?
The correct answer is A. Neither task commits to the database. See the full explanation below for the reasoning.
Question
You write code that makes two SQL Server updates inside an ADO.NET transaction. One statement succeeds. The other statement fails. What happens when the transaction is rolled back?
Options
- ANeither task commits to the database.
- BThe successful task commits to the database.
- CThe code throws an exception.
- DBoth tasks commit to the database.
How the community answered
(55 responses)- A75% (41)
- B7% (4)
- C15% (8)
- D4% (2)
Community Discussion
No community discussion yet for this question.