Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

What is the default transaction isolation level in InnoDB?

  1. A READ UNCOMMITTED
  2. B READ COMMITTED
  3. C REPEATABLE READ
  4. 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.

All MySQL MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as