C. Table B gets created but no row gets inserted into Table A

THE TABLE WILL BE CREATED AND ALL THE ROWS ARE INSERTED INTO TABLE B BUT THEN THERE IS ROLLBACK WHICH WILL DELETE ALL THE ROWS.

SO ANS IS C

Ans: C

Table B gets created. As the syntax for insert is wrong no rows will be inserted in table 'A'.

syntax for insert: insert into A values(a1);

table and value mentioned in the given piece of code are incorrect.

A> Table B gets created with the row inserted in the first statement.
Because all DDL statements are AUTO COMMIT statements and as a create command (a DDL) is issued it is automatically commited and there will not be any effect of rollback....

Vikas Baidya

Option (A) is correct as creation of table is ddl operation which is autocommit

The answer here is quite simple...

first the insert statement will execute and after that a table b will get created with the data stored in the table a.

There will be no effect of the rollback. the data will get saved in the table a because the DDL commands (create alter etc) fires the commit automatically.