A transaction may be in one of the following states during its execution life…
2021
A transaction may be in one of the following states during its execution life cycle in concurrent execution environment.
A. FAILED
B. TERMINATED
C. PARTIALLY COMMITTED
D. COMMITTED
E. ACTIVE
Given a transaction in active state during its execution, find its next transitioned state from the options given below: [
- A.
A only
- B.
Either A or C only
- C.
C only
- D.
D only
Attempted by 355 students.
Show answer & explanation
Correct answer: B
Answer: From the ACTIVE state a transaction can move next to either FAILED or PARTIALLY COMMITTED.
Explanation:
If an error or abort occurs during execution, the transaction leaves ACTIVE and moves to FAILED (and later to TERMINATED after cleanup).
If the transaction proceeds successfully toward commit, it moves from ACTIVE to PARTIALLY COMMITTED, then to COMMITTED, and finally to TERMINATED.
Therefore the correct choice is the option that lists FAILED or PARTIALLY COMMITTED as the next state; COMMITTED and TERMINATED are later states and cannot follow ACTIVE immediately in all cases.
A video solution is available for this question — log in and enroll to watch it.