Open In App

GATE | GATE-CS-2003 | Question 29

Like Article
Like
Save
Share
Report

Which of the following scenarios may lead to an irrecoverable error in a database system ?
(A) A transaction writes a data item after it is read by an uncommitted transaction
(B) A transaction reads a data item after it is read by an uncommitted transaction
(C) A transaction reads a data item after it is written by a committed transaction
(D) A transaction reads a data item after it is written by an uncommitted transaction


Answer: (D)

Explanation: Option C is a normal operation.

Option B is also fine as no write operation is involved.

Option A can be recovered, but option D can’t be.

See this for an example.

Quiz of this Question


Last Updated : 28 Jun, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads