Transaction States in DBMS
Transaction States:
In DBMS, Transaction States are a set of logically related operations. Transaction States are Active, Partially Committed, Failed, Aborted, Committed.
Active: It is the initial state, the transaction stays in the state while it is executing.
Partially Committed: In this state, the final statement of the transaction has been executed.
Failed: When the normal execution of a transaction can no longer proceed then It is failed.
Aborted: In this state, after the transaction has been rollback and the database has been restored to be stated before starting of the transaction.
Committed: In this state, the transaction completed.