Microsoft
70-433 · Question #106
You are writing a batch that contains multiple UPDATE statements to modify existing products. You have placed these updates into one explicit transaction. You need to set an option at the beginning…
The correct answer is B. XACT_ABORT. See the full explanation below for the reasoning.
Question
You are writing a batch that contains multiple UPDATE statements to modify existing products. You have placed these updates into one explicit transaction. You need to set an option at the beginning of the transaction to roll back all changes if any of the updates in the transaction fail. Which option should you enable?
Options
- AARITHABORT
- BXACT_ABORT
- CIMPLICIT_TRANSACTIONS
- DREMOTE_PROC_TRANSACTIONS
How the community answered
(29 responses)- A17% (5)
- B72% (21)
- C3% (1)
- D7% (2)
Community Discussion
No community discussion yet for this question.