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
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
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
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
pieknyjoe
4 years, 5 months agodb2tester
5 years, 1 month ago