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
Quick AnswerThe correct answer is Any pending transactions are rolled back; the structure and data cannot be recovered. because it directly addresses the core logic of Database Management.
This question has been retained as-is due to its unique context.