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
Quick AnswerThe correct answer is The table structure and its data cannot be rolled back and restored once DROP TABLE is executed. because it directly addresses the core logic of Database Management.
DROP TABLE is DDL — it auto-commits and is irreversible without a backup.