Question:
In two-phase locking (2PL), a transaction must be _______ .
In two-phase locking (2PL), a transaction must be _______ .
Show Hint
The two-phase locking protocol ensures serializability and prevents deadlocks by enforcing a strict order in acquiring and releasing locks.
Updated On: Jun 16, 2025
- Release all locks before acquiring new ones
- Acquire all locks before releasing any
- Use only shared locks
- Avoid deadlocks by timeouts
Hide Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
Two-phase locking protocol requires that a transaction must acquire all locks before releasing any. This ensures that the transaction follows the "growing phase" and "shrinking phase," which are essential for preventing deadlocks.
Was this answer helpful?
0
0
Top Questions on Database Management Systems
- What is a primary key in a relational database?
- BITSAT - 2025
- Computer Science
- Database Management Systems
- Which of the following is true about the SQL JOIN operation?
- Karnataka PGCET - 2025
- Computer Science and IT Engineering
- Database Management Systems
- What is a primary key in a relational database?
- TS PGECET - 2025
- Computer Science & Information Technology
- Database Management Systems
- What is normalization in database design?
- TS PGECET - 2025
- Computer Science & Information Technology
- Database Management Systems
The term that optimizes subexpressions shared by different expressions in a program is called ________.
- AP PGECET - 2025
- Computer Science and IT Engineering
- Database Management Systems
View More Questions
Questions Asked in AP PGECET exam
- The probability of a component being defective is 0.01. There are 100 such components in a machine. Then the probability of two or more defective components in the machine is _______
- AP PGECET - 2025
- Probability and Statistics
- A number is selected randomly from each of the following two sets:
{1, 2, 3, 4, 5, 6, 7, 8}, {2, 3, 4, 5, 6, 7, 8, 9}
What is the probability that the sum of the numbers is 9?- AP PGECET - 2025
- Probability and Statistics
- If the function \( f(z) = -x^2 + xy + y^2 + i(ax^2 + bxy + cy^2) \) of complex variable \(z = x + iy\) is analytic in the complex plane, then the values of \(a, b, c\) are _______
- AP PGECET - 2025
- Complex numbers
- Let \( f(x,y) = e^{-x} \sin(-y), g(x,y) = e^{-x} cos(-y) \), and \( C \) be the square with vertices at \( (0,0), (\frac{\pi}{2},0), (\frac{\pi}{2},\frac{\pi}{2}), (0,\frac{\pi}{2}) \). Then, the value of the line integral \( \oint_C [f(x,y)dx + g(x,y)dy] \) is _______
- AP PGECET - 2025
- Calculus
- Let \( A \) be a \(3 \times 3\) matrix and \( B = 2A^2 + A^{-1} - I \), where \( I \) is a \(3 \times 3\) identity matrix. If the eigenvalues of \( A \) are 1, –1 and 2, then the trace of \( B \) is ________
View More Questions