IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 9

Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?

Answer options

• A. A ROLLBACK command executed just after the COMMIT command cancels that COMMIT
• B. Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command
• C. It finishes the current T1 unit of work and a new one is initiated, however it is possible to ROLLBACK to the latest SAVEPOINT before COMMIT
• D. It finishes the current T1 unit of work and a new one is initiated. All changes made by UPDATE and DELETE commands during unit of work T1 are committed

Correct answer: D

Explanation

The correct answer is D because a COMMIT statement finalizes all changes within the T1 unit of work, ensuring that all modifications made by UPDATE and DELETE are saved. Option A is incorrect as a ROLLBACK cannot undo a COMMIT. Option B is false since save points are no longer relevant after a COMMIT. Option C is misleading because while it indicates a new unit of work starts, it incorrectly suggests that ROLLBACK can occur after a COMMIT.