Oracle Database SQL — Question 83

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

Answer options

• A. After issuing a savepoint, you can roll back to the savepoint name within the current transaction.
• B. They make uncommitted updates visible to sessions owned by other users.
• C. You can commit updates done between two savepoints without committing other updates in the current transaction.
• D. A ROLLBACK TO SAVEPOINT command issued before the start of a transaction results in an error.
• E. They make uncommitted updates visible to other sessions owned by the same user.
• F. After issuing a savepoint, you cannot roll back the complete transaction.

Correct answer: A, D

Explanation

Answer A is correct because after a savepoint is created, you can revert to it within the same transaction. Answer D is also correct because attempting to roll back to a savepoint before a transaction has started will indeed result in an error. The other options either misrepresent the behavior of savepoints or are outright incorrect.