Which transaction isolation level options are available in MySQL?
A)READ UNCOMMITTED
B)READ COMMITTED
C)REPEATABLE READ
D)A and B
E)A,B and C

Question

Quizplus · Accepted Answer

All three transaction isolation levels (READ UNCOMMITTED, READ COMMITTED, and REPEATABLE READ) are available in MySQL. However, the best choice depends on the specific requirements of the application. In general, REPEATABLE READ is a good choice for most situations as it provides a high level of consistency while still allowing for concurrent access to the database. READ COMMITTED may be appropriate for applications that require more frequent updates, while READ UNCOMMITTED should only be used in special cases where dirty reads are acceptable.

Which Transaction Isolation Level Options Are Available in MySQL