When working with the InnoDB engine, which of the following correctly defines the READ UNCOMMITTED isolation level?

The correct answer is C. It allows a transaction to see uncommitted changes made by other transactions. READ UNCOMMITTED allows a transaction to see uncommitted changes made by other transactions. This isolation level allows dirty reads, non-repeatable reads, and phantoms to occur.

MySQL Storage Engines

Question

Options

AIt allows a transaction to only see its uncommitted changes.
BIt allows a transaction to see committed changes made by other transactions.
CIt allows a transaction to see uncommitted changes made by other transactions.
DIt allows a transaction to see both committed/uncommitted changes made by other transactions.

How the community answered

(50 responses)

A
4% (2)
B
6% (3)
C
78% (39)
D
12% (6)

Explanation

READ UNCOMMITTED allows a transaction to see uncommitted changes made by other transactions. This isolation level allows dirty reads, non-repeatable reads, and phantoms to occur.

Topics

#READ UNCOMMITTED#isolation levels#InnoDB#dirty reads

Community Discussion

No community discussion yet for this question.

Full 1Z0-873 Practice