MySQL Tutorial

1:

With autocommit off, a transaction will be committed

  1. when you call COMMIT

  2. when you request a lock

  3. both a) and b)

  4. none of the above

2:

Atomicity means

  1. either all of a transaction is performed or none of it is performed

  2. operations transform the database from one consistent state to another

  3. transactions do not interfere with each other

  4. committed transactions should be permanent

3:

Isolation means

  1. either all of a transaction is performed or none of it is performed

  2. operations transform the database from one consistent state to another

  3. transactions do not interfere with each other

  4. committed transactions should be permanent

4:

Durability means

  1. either all of a transaction is performed or none of it is performed

  2. operations transform the database from one consistent state to another

  3. transactions do not interfere with each other

  4. committed transactions should be permanent

5:

In repeatable read mode

  1. you may experience a dirty read

  2. you may experience a nonrepeatable read

  3. you may experience a phantom read

  4. none of the above

Related

Категории