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
Answer: D
Latest D-PVM-DS-23 Dumps Valid Version with 110 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments