Aspire's Library

A Place for Latest Exam wise Questions, Videos, Previous Year Papers,
Study Stuff for MCA Examinations - NIMCET

Previous Year Question (PYQs)

Let $T_1$ be a transaction that transfer Rs. $50$ from account A to account B. This transaction can be defined as follows:

 StepOperation 
1  Read (A)
 2A: A-50 
 3 Write(A)
 4 Read(B)
 5B:=B+50 
 6 Write (B)
What will be the status of a database just after $3^{rd}$ step but before $5^{th}$ step of transaction execution?




Solution

After step $3$, amount Rs. $50$ has been deducted from account A.

But before step $5$, Rs. $50$ has not yet been added to account B.

So, for some time, the total balance may not match the original total balance.

Therefore, the database may be temporarily inconsistent.

So, correct option is:

$\boxed{(b)\ \text{May be temporarily inconsistent}}$

Online Test Series,
Information About Examination,
Syllabus, Notification
and More.

Click Here to
View More

Online Test Series,
Information About Examination,
Syllabus, Notification
and More.

Click Here to
View More
Ask Your Question or Put Your Review.

loading...