Which statement is true when a DROP TABLE command is executed on a table?
Answer options
A
The table structure and its data cannot be rolled back and restored once DROP TABLE is executed.
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: The table structure and its data cannot be rolled back and restored once DROP TABLE is executed.
Explanation
DROP TABLE is DDL — it auto-commits and is irreversible without a backup.