Which statement about roll back operations is correct?
A.
When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the
savepoint are released.
B.
When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the
savepoint are released.
C.
When a ROLLBACK statement is executed, all locks held by the terminating transaction
are released.
D.
When a ROLLBACK statement is executed, all locks acquired for open cursors that were
declared WITH HOLD, are held
Explanation:
C)
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000992.html
All locks are retained after a ROLLBACK TO SAVEPOINT statement.
0
0