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.