Quiz


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




MySQL Tutorial
MySQL Tutorial
ISBN: 0672325845
EAN: 2147483647
Year: 2003
Pages: 261

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net