Which of the following scenario may lead to an irrecoverable error in a database system?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: D. A transaction reads a data item after it is written by an uncommitted transaction.
Explanation
Reading a value written by an uncommitted transaction is a dirty read. If the reader commits and the writer then aborts, the schedule cannot be recovered.
More Database Management Systems questions
- Given the basic E R diagram and relational model, which of the the following is incorrect?
- Given below are two statements: Which of the following concurrency control protocol ensures both conflict serializability and freedom from…
- Let T1 transfer ₹50 from account A to account B: 1 Read(A); 2 A := A − 50; 3 Write(A); 4 Read(B); 5 B := B + 50; 6 Write(B). What is the st…
- Consider the relation Student(stuid, dept, clsroll) with FDs: FD1: stuid → dept, FD2: dept → stuid, FD3: stuid → clsroll, FD4: clsroll → st…
- Match List I with List II
- Consider the schedule S: t1: R2(X), R3(Y); t2: W2(X), W3(Y); t3: R1(Y), R4(X); t4: W1(Y), W4(X); t5: R3(X); t6: W3(X). Choose the correct s…