Database Management
Accenture PrimereasyDatabase Management5. Sql Select Statement

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

DROP TABLE is DDL — it auto-commits and cannot be rolled back.

Related Accenture Database Management questions

Tom has designed a payroll software for XYZ technology.The sofware will store the salary details into the database and l…In SQL is a case sensitive language and the data stored inside the table are case in-sensitive. Say true or false?Which of the following is not a valid relational database?Database is a shared collection of logically unrelated data, designed to meet the needs of an organization. State True o…Which of the following represents the degree of the relation?A table consists of ______ primary keys.

Practice more Accenture Database Management questions

PrimerDumps has 1400+ primer questions, 2026 mocks and coding hands-on — all free.

Database Management question bankAll subjects