Oracle Database SQL — Question 197

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. Only one SAVEPOINT may be issued in a transaction.
• C. Rolling back to a SAVEPOINT can undo a DELETE statement.
• D. A SAVEPOINT does not issue a COMMIT.
• E. Rolling back to a SAVEPOINT can undo a TRUNCATE statement.

Correct answer: C, D

Explanation

The correct answers are C and D. Rolling back to a SAVEPOINT can indeed undo a DELETE statement, while a SAVEPOINT itself does not result in a COMMIT being issued. Options A, B, and E are incorrect because a SAVEPOINT can only undo certain operations, and multiple SAVEPOINTS can be set within a single transaction.