The SQL statements executed in a user session as follows: Exhibit: Which two statements describe the consequence of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two.)
A.
Both the DELETE statements and the UPDATE statement are rolled back
B.
The rollback generates an error
C.
Only the DELETE statements are rolled back
D.
Only the seconds DELETE statement is rolled back
You ended this transaction (COMMIT) and all savepoints what was set in this transaction was deleted. No more save points to rollback.
ORA-01086: savepoint save never established
01086. 00000 - "savepoint '%s' never established in this session or is invalid"
*Cause: An attempt was made to roll back to a savepoint that was never
established in this session, or was invalid.
*Action: Try rolling back to the savepoint from the session where it is established.
This section is not available anymore. Please use the main Exam Page.1z0-061 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
duongvietnam
5 years, 8 months agohggz
5 years, 7 months agoduongvietnam
5 years, 7 months ago