Question:
Which concurrency control technique ensures that transactions are executed in a serial order?
Which concurrency control technique ensures that transactions are executed in a serial order?
Show Hint
Which protocol has a growing phase and a shrinking phase and guarantees conflict serializability?
Updated On: Jul 2, 2026
- Optimistic Concurrency Control
- Deadlock Prevention
- Two-Phase Locking (2PL)
- Time-Stamp Ordering
Show Solution
Verified By Collegedunia
The Correct Option is C
Solution and Explanation
Step 1: Concurrency control aims to produce schedules that are equivalent to some serial order of transactions, that is, serializable schedules.
Step 2: Two-Phase Locking (2PL) forces every transaction into a growing phase (acquire locks) and a shrinking phase (release locks). Once a transaction releases a lock it can never acquire a new one.
Step 3: This rule guarantees conflict serializability, so the outcome is always equivalent to executing the transactions one after another in a serial order. Optimistic control and deadlock prevention do not by themselves guarantee this ordering.
Step 2: Two-Phase Locking (2PL) forces every transaction into a growing phase (acquire locks) and a shrinking phase (release locks). Once a transaction releases a lock it can never acquire a new one.
Step 3: This rule guarantees conflict serializability, so the outcome is always equivalent to executing the transactions one after another in a serial order. Optimistic control and deadlock prevention do not by themselves guarantee this ordering.
Was this answer helpful?
0
0
Top CPET Computer Science Questions
- Which of the following is a key reason for choosing DRAM over SRAM for main memory?
- Which of the following components in an FPGA is responsible for implementing combinational and sequential logic?
- What is the main purpose of declaring a base class as virtual in multiple inheritance?
- What happens if a class contains at least one pure virtual function?
- What happens if a derived class defines a function with the same name as a base class function, but with a different parameter list?
View More Questions
Top CPET Questions
- Which of the following is a key reason for choosing DRAM over SRAM for main memory?
- Which of the following components in an FPGA is responsible for implementing combinational and sequential logic?
- What is the main purpose of declaring a base class as virtual in multiple inheritance?
- What happens if a class contains at least one pure virtual function?
- What happens if a derived class defines a function with the same name as a base class function, but with a different parameter list?
View More Questions