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 a transaction.
B. Change the isolation level.
C. Use the TABLOCK query hint.
D. Use the UPDLOCK query hint.
