Question

Geetanjali had created a table "Customer" in the database "Test". Immediately after the successful creation of the database, she wrote the Rollback command to undo the creation of the table. Did she execute rollback successfully? Explain'

Answer 1

A table in MYSQL is created using CREATE TABLE command which is a DDL command. A DDL command cannot be rolled back. hence, she needs to use the DROP TABLE command to remove the table.