Multiple choice

Consider the following command:

DROP TABLE ITEM;

An explicit COMMIT has NOT been issued. What can be done to reverse this action and restore the data in the INVENTORY table?

  1. Shut down the database

  2. Terminate your current session

  3. The action cannot be reversed

  4. Issue a ROLLBACK
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DDL statements like DROP TABLE include an implicit COMMIT before execution and another COMMIT after execution, meaning the transaction is permanently committed before ROLLBACK can be issued. Once the DROP TABLE executes, the data is gone (unless using Flashback Drop in 10g+). Shutting down the database or terminating the session won't undo a committed DDL operation.

Keep practicing — related questions