+3 votes
in Class 12 by kratos

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 *** rollback successfully? Explain'

1 Answer

+4 votes
by kratos
 
Best answer

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.

...