What is dirty read in the context of transaction processing?

2025

What is dirty read in the context of transaction processing?

  1. A.

    A transaction reads data that was modified by another transaction but not yet committed

  2. B.

    A transaction reads data that is in a buffer but not written to disk

  3. C.

    A transaction reads data after it has been committed

  4. D.

    A transaction write data that other transaction can read immediately

Attempted by 114 students.

Show answer & explanation

Correct answer: A

A dirty read occurs when a transaction reads data that has been modified by another concurrent transaction but not yet committed. If the modifying transaction rolls back, the reading transaction will have accessed invalid data.

Explore the full course: Mppsc Assistant Professor