Question

Which statement is true when a DROP TABLE command is executed on a table?
Select one:
Oa. Any pending transactions on the table are rolled back.

b. Only a DBA can execute the DROP TABLE command.

c. The structure of the table remains in the database, and the data and indexes are deleted.

d. The DROP TABLE command can be executed on a table on which there are pending
transactions.

e. The table structure and its deleted data cannot be rolled back and restored once the DROP TABLE command is executed.​

Answer 1

Answer:

A. Any pending transactions on the table are rolled back.

Answer 2

Answer:

Option e is correct.

The table structure and its deleted data cannot be rolled back and restored once the DROP TABLE command is executed.