PrepAway - Latest Free Exam Questions & Answers

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

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

Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_commit.html


Leave a Reply