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:
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. Either A or C only
Explanation
From ACTIVE a transaction moves to PARTIALLY COMMITTED (last statement done) or FAILED (error).
More Database Management Systems questions
- Which of the following is used to create a database schema?
- The data node and name node in HADOOP are
- Consider a relational schema S = (U, V , W, X, Y , Z) on which the following functional dependencies hold: {U → V , V W → X, Y → W, X → U}…
- In the context of concurrency control, a given pair of operations in a schedule is called conflict schedule if (A) At least one of the oper…
- Match List I with List II.
- On the basis of above given table structures, retrieve the distinct employee ID (EMPID) of all employees of university who are working on p…