State Diagram of a Transaction
The following are the states of the above ‘State Transition Diagram’ :
ACTIVE: The initial state; the state remains constant while the transaction executes.
PARTIALLY COMMITTED: After the final statement has been executed.
FAILED: After the discovery that normal execution can no longer proceed.
ABORTED: The state after transaction roll-back and data restoration to the start of the transaction
COMMITTED: After successful completion.
Reference Link