Oracle
1Z0-074 · Question #94
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. Explanation/Reference:
Administering a Multitenant Container Database
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
(23 responses)- A74% (17)
- B13% (3)
- C4% (1)
- D9% (2)
Explanation
Explanation/Reference:
Topics
#SAVEPOINT#transaction control#ROLLBACK#TCL
Community Discussion
No community discussion yet for this question.