Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 138

Which two are true about savepoints? (Choose two.)

After issuing a savepoint, you can roll back to the savepoint name within the current transaction.

They make uncommitted updates visible to sessions owned by other users.

You can commit updates done between two savepoints without committing other updates in the current transaction.

A ROLLBACK TO SAVEPOINT command issued before the start of a transaction results in an error.

They make uncommitted updates visible to other sessions owned by the same user.

After issuing a savepoint, you cannot roll back the complete transaction.

Correct Answer: A, D

Savepoints allow a transaction to be partially rolled back, restoring the database to a specific point without affecting subsequent operations. Firstly, after creating a savepoint, you can roll back to that savepoint within the current transaction; this makes 'A' correct. Secondly, issuing a ROLLBACK TO SAVEPOINT command before the start of a transaction results in an error, as there would be no savepoint to roll back to; this makes 'D' correct. Therefore, the correct answers are A and D.

Discussion

McromeoOptions: AD

AD is correct

lucemqyOptions: AD

AD is correct

lucemqyOptions: AB

AB should be the correct answer

Mcromeo

No B is not correct. An uncommited DML operation made by a session is not visible for other session even if it's the same user

kesammy9Options: AD

https://www.examtopics.com/discussions/oracle/view/20279-exam-1z0-071-topic-2-question-52-discussion/