MySQL
Multiple Choice
Answer as soon as possible
1. Which one of the following is NOT anisolation 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 usingthe following command:
(a) MYSQL doesn’t ley you change the isolation level
(b) SET ISOLATION LEVEL <level>;
(c) SET SESSION TRANSACTION ISOLATION LEVEL <level>;
(d) SET SESSION ISOLATION LEVEL <level>;
(e) SET SESSION INNODB ISOLATION LEVEL <level>;
3. In a deadlock the transactions will waitforever for each other to complete, unless something intervenes tobreak the deadlock.
(a) True
(b) False
4. Which one of the following is NOT a type oflock that MySQL supports?
(a) Deadbolt
(b) Name
(c)
PayPal Gateway not configured
PayPal Gateway not configured