Oracle
1Z0-061 · Question #168
The SQL statements executed in a user session as follows: Which two statements describe the consequence of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two.)
The correct answer is B. The rollback generates an error E. No SQL statements are rolled back. See the full explanation below for the reasoning.
Question
The SQL statements executed in a user session as follows:
Which two statements describe the consequence of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two.)
Exhibit
Options
- ABoth the DELETE statements and the UPDATE statement are rolled back
- BThe rollback generates an error
- COnly the DELETE statements are rolled back
- DOnly the seconds DELETE statement is rolled back
- ENo SQL statements are rolled back
How the community answered
(28 responses)- A11% (3)
- B82% (23)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.