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.
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.