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 ________.
- A.
Temporary Select Problem
- B.
Temporary Modify Problem
- C.
Dirty Read Problem
- 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.