Oracle MySQL 5 Database Administrator Certified Professional Set 3

Shared tablespace files are not needed. ✘ Occasionally shared tablespace files are still needed. ✘ Shared tablespace files are still needed. ✘ Per-table tablespace files cannot be used with InnoDB. ✔

Autocommit mode overrides BEGIN TRANSACTION and START TRANSACTION. ✘ Autocommit mode is suspended and has to be re-enabled explicitly. ✘ Autocommit mode is suspended until COMMIT. ✘ Nothing happens as they are not valid commands. ✔

Within a transaction, you can define multiple savepoints ✘ All savepoints must have unique identifiers ✘ You can rollback to any previous savepoint. ✘ You can rollback to only the latest savepoint. ✔ If you rollback to a previous savepoint, all statements after this savepoint are rolled back and cannot bereissued. ✔

1 ✘

Deadlocks happen anytime when more than one lock is placed in a table. Deadlocks happen when two transactions both have locks that the other is waiting for the release of the lockthat the other holds. InnoDB resolves deadlocks by terminating and rolling back one of the deadlocking transactions. InnoDB resolves deadlocks by terminating and rolling back both of the deadlocking transactions.

When you need a lock that does not allow other transactions to read, update or delete the same data until

released. ✘ When you need a lock that allows other transactions to read the same data, but not update or delete untilreleased. ✘ When you need a lock that allows other transactions to read, update and delete the same locked data. ✘

You intend to run more than ten UPDATE statements in one transaction. ✘ You intend to execute an UPDATE statement on any row. ✘ You intend to SELECT a set of rows, then modify those rows. ✘

A dirty read is a read by one transaction of uncommitted changes made by another transaction. ✘ A dirty read is a read by one transaction of its uncommitted changes. ✘ A non-repeatable read occurs when a transaction performs the same retreival twice but gets a differentresult each time. ✘ A non-repeatable read is a row that appears where it was not visible before. ✔ A phantom is a row that appears where it was not visible before. ✔

It allows a transaction to only see its uncommitted changes. ✘ It allows a transaction to see committed changes made by other transactions. ✘ It allows a transaction to see uncommitted changes made by other transactions. ✘ It allows a transaction to see both committed/uncommitted changes made by other transactions. ✔

It allows a transaction to just see its committed changes. ✘ It allows a transaction to see committed changes made by other transactions. ✘ It allows a transaction to see uncommitted changes made by other transactions. ✘