Oracle Database Administration I — Question 74

Which two statements are true regarding a SAVEPOINT? (Choose two.)

Answer options

• A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
• B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
• C. Only one SAVEPOINT may be issued in a transaction
• D. A SAVEPOINT does not issue a COMMIT
• E. Rolling back to a SAVEPOINT can undo a DELETE statement

Correct answer: D, E

Explanation

The correct answers are D and E. A SAVEPOINT does not execute a COMMIT, allowing for the possibility to roll back to that point without finalizing any changes. Rolling back to a SAVEPOINT can undo a DELETE statement, but not a TRUNCATE statement, as TRUNCATE is a DDL command and cannot be rolled back.