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.
Which two statements are true about the COMMIT WORK statement? (Choose two.)
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Which two statements are true about the COMMIT WORK statement? (Choose two.)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!