Oracle Database SQL — Question 34

No user-defined locks are used in your database.
Which three are true about Transaction Control Language (TCL)? (Choose three.)

Answer options

• A. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes, releases its locks, and erases all its savepoints.
• B. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not release its locks.
• C. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction's changes but does not erase its savepoints.
• D. ROLLBACK TO SAVEPOINT undoes the transaction's changes made since the named savepoint and then ends the transaction.
• E. COMMIT ends the transaction and makes all its changes permanent.
• F. COMMIT erases all the transaction's savepoints and releases its locks.

Correct answer: A, E, F

Explanation

The correct answers A, E, and F accurately describe the behavior of ROLLBACK and COMMIT in TCL. Option A correctly states that ROLLBACK without TO SAVEPOINT undoes all changes and releases locks. Option E explains that COMMIT finalizes changes, while option F details that COMMIT also removes savepoints and releases locks. Options B and C are incorrect as they misrepresent the effects of ROLLBACK, and option D incorrectly states the behavior of ROLLBACK TO SAVEPOINT.