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, transaction stays the state while it is executing.

Partially Committed: In this state, the final statement of transaction has been executed.

Failed: When 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 successfully completed.
States Transaction