
Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
The different transaction states in a database system, including the active state, partially committed state, committed state, failed state, aborted state, and terminated state. The failed state occurs when a transaction cannot continue due to a failure, requiring it to be undone and enter the aborted state. The terminated state marks the end of a transaction's life cycle.
Typology: Assignments
1 / 1
This page cannot be seen from the preview
Don't miss anything!

Transaction states are- Active state, Partially committed state, Committed state, Failed state, Aborted state, Terminated state.
1. Failed State: When a transaction is getting executed in the active state or partially committed state and some failure occurs due to which it becomes impossible to continue the execution, it enters into a failed state. 2. Aborted State: After the transaction has failed and entered into a failed state, all the changes made by it have to be undone. To undo the changes made by the transaction, it becomes necessary to roll back the transaction. After the transaction has rolled back completely, it enters into an aborted state. 3. Terminated State : This is the last state in the life cycle of a transaction. After entering the committed state or aborted state, the transaction finally enters into a terminated state where its life cycle finally comes to an end.