Which two statements are true about the COMMIT WORK statement? (Choose two.)
Posted: Fri Aug 26, 2022 9:58 am
Which two statements are true about the COMMIT WORK statement? (Choose two.)
A. The keyword WORK is optional.
B. A single COMMIT WORK can end several BEGIN WORK statements.
C. The COMMIT WORK statement releases all row locks but not table locks.
D. All of the successful modifications that the transaction makes are saved to disk when you issue a COMMIT WORK statement. E. A new transaction automatically starts after each COMMIT WORK or ROLLBACK WORK statement in a nonlogged database.
A. The keyword WORK is optional.
B. A single COMMIT WORK can end several BEGIN WORK statements.
C. The COMMIT WORK statement releases all row locks but not table locks.
D. All of the successful modifications that the transaction makes are saved to disk when you issue a COMMIT WORK statement. E. A new transaction automatically starts after each COMMIT WORK or ROLLBACK WORK statement in a nonlogged database.