1 1. Default autocommit mode.
2 create table with all datatypes.
4 Rollback the transaction.
5 Records should not be rolled back
7 Records should not be rolled back
9 Records should not be rolled back
11 2. Autocommit mode off
12 create table with all datatypes.
14 Commit the transaction.
15 Rollback after commit should not have any effect.
17 Rollback the transaction
18 Transaction should be rolled back
22 All the 3 transactions should be rolled back with rollback statement.
26 All the 3 transactions should be committed back with commit statement.