Answer to Question #273315 in Databases | SQL | Oracle | MS Access for Robin

Question

Suppose you are given a transaction:

read(A);

A:= A - 150;

write(A);

read(B);

B:= B + 150;

Write (B).

Now, describe A-C-I-D properties for the above transaction.

Answer 1

ACID Properties:

ATOMICITY: It states that either all the operations of a transaction are executed or NULL.

ISOLATION: It states that each transaction of the concurrent schedule is unaware from another transaction that is parallel executed even if that transaction is executed on same data item.

DURABILITY: It states that after the successful execution of the transaction on the database all the modifications must be reflected on the database even after the system failure.

CONSISTENCY: It states that after the execution of a transaction the database must be in the consistent state (as that before execution).