Oracle
1Z0-873 · Question #37
When working with the InnoDB storage engine, which of the following correctly defines the READ COMMITTED isolation level?
The correct answer is B. It allows a transaction to see committed changes made by other transactions. READ COMMITTED allows a transaction to see changes made by other transactions only if they've been committed. Uncommitted changes remain invisible. This isolation level allows non- repeatable reads and phantoms to occur.
MySQL Storage Engines
Question
When working with the InnoDB storage engine, which of the following correctly defines the READ COMMITTED isolation level?
Options
- AIt allows a transaction to just see its committed 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.
How the community answered
(24 responses)- A13% (3)
- B71% (17)
- C17% (4)
Explanation
READ COMMITTED allows a transaction to see changes made by other transactions only if they've been committed. Uncommitted changes remain invisible. This isolation level allows non- repeatable reads and phantoms to occur.
Topics
#READ COMMITTED#isolation levels#InnoDB#committed changes
Community Discussion
No community discussion yet for this question.