You have a database that contains two tables. Both the XACT_ABORT database option and
the IMPLICIT_TRANSACTIONS database option are set to OFF. You need to update both
tables. If an update fails on either table, neither table should be updated. What should you
do?
A.
Use the UPDLOCK query hint.
B.
Use a transaction.
C.
Change the isolation level.
D.
Use the TABLOCK query hint.