Let Ti be a transaction that transfers Rs. 50 from account A to account B.…

PYQ UGC NET 2022

Let Ti be a transaction that transfers Rs. 50 from account A to account B. This transaction can be defined as follows:

Step

Operation

1

Read(A)

2

A:=A − 50

3

Write(A)

4

Read(B)

5

B:=B + 50

6

Write(B)

What will be the status of a database just after 3rd step but before 5th step of transaction execution?

  1. A.

    Always consistent

  2. B.

    May be temporarily inconsistent

  3. C.

    Must be abort

  4. D.

    Always rollback

Attempted by 47 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…