Transaction States in DBMS
The transaction has one of the following states are given as follows:
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.