What is the result after issuing the ROLLBACK command?

Consider the following SQL statement which is using the InnoDB storage engine and with global AUTOCOMMIT=1.BEGIN;CREATE TABLE t1 (c1 INT);CREATE TABLE t2 (c1 INT); ROLLBACK;What is the result after issuing the ROLLBACK command?

Question:

What is the result after issuing the ROLLBACK command?

Options:

Both the tables, t1 and t2, are created.

Only the t1 table is created.

Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.

Only the t2 table is created.

Correct Answer

The Correct Answer for this Question is

Both the tables, t1 and t2, are created.