Oracle
1Z0-082 · Question #56
Which two statements are true regarding a SAVEPOINT? (Choose two.)
The correct answer is D. A SAVEPOINT does not issue a COMMIT E. Rolling back to a SAVEPOINT can undo a DELETE statement. See the full explanation below for the reasoning.
Manage Data Concurrency
Question
Which two statements are true regarding a SAVEPOINT? (Choose two.)
Options
- ARolling back to a SAVEPOINT can undo a CREATE INDEX statement
- BRolling back to a SAVEPOINT can undo a TRUNCATE statement
- COnly one SAVEPOINT may be issued in a transaction
- DA SAVEPOINT does not issue a COMMIT
- ERolling back to a SAVEPOINT can undo a DELETE statement
How the community answered
(38 responses)- A8% (3)
- B11% (4)
- C3% (1)
- D79% (30)
Topics
#SAVEPOINT#transaction control#ROLLBACK#DML
Community Discussion
No community discussion yet for this question.