MySQL Multiple Choice

1. Transactions isolate sql statements so that other transactions don't see the changes to the data outside their own transaction. (a) True (b) False

2. A ROLLBACK; command reverses the transaction and cancels all the changes made up to that point in the transaction. (a) True (b) False

3. A FINALIZE; command finalizes the transaction and makes the changes in the transaction up that point permanent. (a) True (b) False

4. In an isolated consistent backup (a backup where the it is performed in a transaction), the changes made by other users cannot affect the backup, while the backup is in progress. (a) True (b) False

5. Both MyISAM and InnoDB support transactions. (a) True (b) False

6. The following command locks a table preventing others from writing to the table, but still allows others to read from the table: LOCK TABLES table1 READ; (a) True (b) False

7. A deadlock would occur if Transaction #1 has a lock on id=1 and id=2 while Transaction #2 had a lock on id = 2 and now attempts to lock id=1. (a) True (b) False

8. MySQL detects and automatically resolves deadlocks for you by rolling back one of the conflicting transactions. (a) True (b) False

9. SQL commands that modify the database and table structure (such as ALTER TABLE) can be incorporated into transactions and will be reversed if the transaction is rolled back. (a) True (b) False

10. By changing the default isolation level we can see the uncommitted changes made by other pending transactions. (a) True (b) False