Which statement is true when a DROP TABLE command is executed on a table?
Answer options
A
Any pending transactions on the table are rolled back. The table structure and its deleted data cannot be rolled back and restored once the DROP TABLE command is execute
B
The DROP TABLE command can be executed on a table on which there are pending transactions.
Correct answer: Any pending transactions on the table are rolled back. The table structure and its deleted data cannot be rolled back and restored once the DROP TABLE command is execute
Explanation
Quick AnswerThe correct answer is Any pending transactions on the table are rolled back. The table structure and its deleted data cannot be rolled back and restored once the DROP TABLE command is execute because it directly addresses the core logic of Database Management.
DROP TABLE is DDL — it auto-commits and cannot be rolled back.