PrepAway - Latest Free Exam Questions & Answers

Which option should you enable?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
ARITHABORT

B.
XACT_ABORT

C.
IMPLICIT_TRANSACTIONS

D.
REMOTE_PROC_TRANSACTIONS


Leave a Reply