Oracle
1Z0-071 · Question #366
Which two statements are true regarding a SAVEPOINT? (Choose two.)
The correct answer is A. 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.
Question
Which two statements are true regarding a SAVEPOINT? (Choose two.)
Options
- AA SAVEPOINT does not issue a COMMIT
- BOnly one SAVEPOINT may be issued in a transaction
- CRolling back to a SAVEPOINT can undo a TRUNCATE statement
- DRolling back to a SAVEPOINT can undo a CREATE INDEX statement
- ERolling back to a SAVEPOINT can undo a DELETE statement
How the community answered
(20 responses)- A80% (16)
- B5% (1)
- C10% (2)
- D5% (1)
Community Discussion
No community discussion yet for this question.