IBM
C2090-320 · Question #54
Which of the following statements is TRUE when issuing an SQL ROLLBACK (without SAVEPOINT) statement?
The correct answer is D. All cursors are closed, all prepared statements are retained, and any cursors that are associated. See the full explanation below for the reasoning.
Question
Which of the following statements is TRUE when issuing an SQL ROLLBACK (without SAVEPOINT) statement?
Options
- AAll held LOB locators are retained
- BAll locks that are implicitly acquired during the unit of recovery are retained
- CAll rows and all logical work files of every created temporary table of the application process are
- DAll cursors are closed, all prepared statements are retained, and any cursors that are associated
How the community answered
(46 responses)- A7% (3)
- B11% (5)
- C4% (2)
- D78% (36)
Community Discussion
No community discussion yet for this question.