IBM
C2090-610 · Question #110
Which statement about roll back operations is correct?
The correct answer is A. When a ROLLBACK statement is executed, all locks held by the terminating transaction are. See the full explanation below for the reasoning.
Question
Which statement about roll back operations is correct?
Options
- AWhen a ROLLBACK statement is executed, all locks held by the terminating transaction are
- BWhen a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the
- CWhen a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the
- DWhen a ROLLBACK statement is executed, all locks acquired for open cursors that were
How the community answered
(45 responses)- A78% (35)
- B2% (1)
- C13% (6)
- D7% (3)
Community Discussion
No community discussion yet for this question.