With autocommit off, a transaction will be committed
when you call COMMIT
when you request a lock
both a) and b)
none of the above
Atomicity means
either all of a transaction is performed or none of it is performed
operations transform the database from one consistent state to another
transactions do not interfere with each other
committed transactions should be permanent
Isolation means
Durability means
In repeatable read mode
you may experience a dirty read
you may experience a nonrepeatable read
you may experience a phantom read