Transaction

Question 1

Transaction state diagram

Answer 1

L-22 slide 11
Active–>partially commited–>Commited–>end

partially commited ke baad transaction agar fail ho jaye toh transaction rollback hoke abort hojata hai..

Question 2

Acid properties?

Answer 2

A=Atomicity .
transaction must be treated as a atomic substance . So either a transaction may be completed 100% or else it will roll back to 0%..

C=Consistency..(sum before equal sum after)

I=isolation(Intermediate transaction results must be hidden from other concurrently executed
transactions)

D=Durability(when transaction is completely successfully,then changes have to saved in database.