Which statement about roll back operations is correct?

A.
When a ROLLBACK statement is executed, all locks held by the terminating transaction are
released.

B.
When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the
savepoint are released.

C.
When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the
savepoint are released.

D.
When a ROLLBACK statement is executed, all locks acquired for open cursors that were
declared WITH HOLD, are held.

Explanation: