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 state of the database just after step 3 but before step 5?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. May be temporarily inconsistent
Explanation
After Write(A) but before B is updated, ₹50 has left A without reaching B, so the database is temporarily inconsistent; it becomes consistent again when the transaction completes.
More Database Management Systems questions
- 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…
- Given below are the two statements: Statement I : Any retrieval request that is specified in the basic relational algebra can also be speci…
- Which of the following queries would retrieve the roll number and names of students who have enrolled for all the prerequisite courses of t…
- Given query: select s.rollno from students where s.sex = ALL (select f.sex from professor f where f.empid = s.advisor). Consider the follow…