The problem that occurs when one transaction updates a database item and then…

2012

The problem that occurs when one transaction updates a database item and then the transaction fails for some reason is ________.

  1. A.

    Temporary Select Problem

  2. B.

    Temporary Modify Problem

  3. C.

    Dirty Read Problem

  4. D.

    None

Attempted by 188 students.

Show answer & explanation

Correct answer: D

Solution:

According to standard DBMS concepts, the situation described in the question is commonly associated with the Temporary Update Problem. This occurs when a transaction updates a database item and later fails before committing.

However, in the given options:

  • “Temporary Select Problem” and

  • “Temporary Modify Problem”

are not standard DBMS anomaly terms.

Many students relate this situation to the “Dirty Read Problem” because dirty reads can occur due to uncommitted updates. But technically, Dirty Read specifically requires another transaction to read that uncommitted data, which is not mentioned in the question.

Therefore, according to the official UGC NET answer key, the correct answer is:

None of these

Important Understanding:

  • Practical/industry interpretation → Dirty Read

  • Academic/UGC NET terminology → Temporary Update Problem

  • Since “Temporary Update Problem” is not present in the options, “None of these” becomes the technically correct answer.

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Mppsc Assistant Professor