Oracle
1Z0-071 · Question #374
Which two are true about savepoints? (Choose two.)
The correct answer is A. After issuing a savepoints, you can roll back to the savepoint name within the current transaction. E. You can commit updates done between two savepoints without committing other updates in the. Statements/SAVEPOINT.htm
Manipulating Data
Question
Which two are true about savepoints? (Choose two.)
Options
- AAfter issuing a savepoints, you can roll back to the savepoint name within the current transaction.
- BA ROLLBACK TO SAVEPOINT command issued before the start of a transaction results in an
- CThey make uncommitted updates visible to other sessions owned by the same user.
- DAfter issuing a savepoint, you cannot roll back the complete transaction.
- EYou can commit updates done between two savepoints without committing other updates in the
- FThey make uncommitted updates visible to sessions owned by other users.
How the community answered
(52 responses)- A71% (37)
- B4% (2)
- C17% (9)
- D2% (1)
- F6% (3)
Explanation
Statements/SAVEPOINT.htm
Topics
#savepoints#ROLLBACK TO SAVEPOINT#transaction control#partial rollback
Community Discussion
No community discussion yet for this question.