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?
A. Both the tables, t1 and t2, are created.
B. Only the t1 table is created.
C. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.
D. Only the t2 table is created.
|
Download Printable PDF. VALID exam to help you PASS. |
 |