Exit C2090-616 DB2 11.1 Fundamentals for LUW
Question 1 of 5
0% complete
Q1 Single choice

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

  • 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.

Previous Next