MySQL Multiple Choice Answer as soon as possible

1. Which one of the following is NOT an isolation level available in MySQL? (a) QUARANTINE (b) READ COMMITTED (c) REPEATABLE READ (d) SERIALIZABLE (e) READ UNCOMMITTED

2. MySQL lets you set the isolation level using the following command: (a) MYSQL doesn't ley you change the isolation level (b) SET ISOLATION LEVEL ; (c) SET SESSION TRANSACTION ISOLATION LEVEL ; (d) SET SESSION ISOLATION LEVEL ; (e) SET SESSION INNODB ISOLATION LEVEL ;

3. In a deadlock the transactions will wait forever for each other to complete, unless something intervenes to break the deadlock. (a) True (b) False

4. Which one of the following is NOT a type of lock that MySQL supports? (a) Deadbolt (b) Name (c) Global (d) Table (e) String

5. What is the default isolation level in MySQL? (a) QUARANTINE (b) READ UNCOMMITTED (c) SERIALIZABLE (d) REPEATABLE READ (e) READ COMMITTED

6. MySQL hides all the details regarding locks and prevents you from seeing any of the details regarding locks. (a) True (b) False

7. Deadlocks occur when transactions try to lock resources in the same order. (a) True (b) False

8. In MySQL the INNODB table storage engine will detect and rollback transaction(s) that are causing a deadlock. (a) True (b) False

9. Which of the following creates a new table called high_scores with MyISAM as the table storage engine? (a) CREATE TABLE high_scores (id INT, score INT) STORAGE AS MyISAM; (b) CREATE TABLE high_scores (id INT, score INT) ENGINE = MyISAM; (c) CREATE TABLE high_scores (id INT, score INT) STORAGE = MyISAM; (d) CREATE TABLE high_scores (id INT, score INT) ENGINE AS MyISAM;

10. A deadlock is when two or more transactions are mutually holding and requesting locks on the same resources, creating a cycle of dependencies. (a) True (b) False