Examice

Exam C2090-616 All QuestionsBrowse all questions from this exam

Question 7

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

A ROLLBACK command executed just after the COMMIT command cancels that COMMIT

Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command

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

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

A COMMIT statement concludes the current transaction, making all changes made by UPDATE and DELETE commands permanent. Once the COMMIT is complete, a new unit of work is initiated, and it is not possible to undo the committed changes with a ROLLBACK command. Thus, the correct choice is that it finishes the current T1 unit of work and a new one is initiated, committing all changes made during T1.

Discussion

pieknyjoeOption: D

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

db2tester

The good reference is https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000903.html