What is the default transaction isolation level in InnoDB?
- A READ UNCOMMITTED
- B READ COMMITTED
- C REPEATABLE READ
- D SERIALIZABLE
Answer
REPEATABLE READ
REPEATABLE READ gives each transaction a consistent snapshot from its first read. InnoDB additionally uses gap locks, which largely prevents phantom reads too.





