Which statement is true when a DROP TABLE command is executed on a table?
Answer options
A
Any pending transactions are rolled back; the structure and data cannot be recovered.
B
The DROP TABLE command can be executed on a table with pending transactions.
C
Only a DBA can execute the DROP TABLE command.
D
The data can be rolled back after DROP TABLE.
Correct answer: Any pending transactions are rolled back; the structure and data cannot be recovered.
Explanation
DROP TABLE is DDL — it auto-commits, rolls back pending transactions, and is irreversible without a backup.