Question
Transaction T1 holds a lock on Row A and requests a lock on Row
Transaction T1 holds a lock on Row A and requests a lock on Row
B. Transaction T2 holds a lock on Row B and requests a lock on Row
A. Both use strict Two-Phase Locking. What will happen, and how is it typically resolved?
More IT DBMS Questions
- In two-phase locking, a transaction releases its locks:
- Which constraint ensures that no duplicate values exist in a column?
- Which query correctly finds department IDs where the average salary exceeds the overall average salary across all employees?
- A B+ tree index is built on an attribute used mainly for range queries. Why is a B+ tree generally preferable to a hash index for this workload?
- Consider the schedule S: R1(A), R2(A), W1(A), W2(A), where Ri and Wi denote read and write by transaction Ti. Which statement about S is correct?
- The 'thrashing' in an operating system is related to:
- What is an 'ER Diagram' (Entity-Relationship Diagram) used for in database design?
- HTTPS ensures which of the following?
- What is a table joined with itself called?
- What is a page fault?
Hey! Ask a query
Please enter email id
The email must be a valid email address.
Please enter Mobile Number
Please enter valid Mobile Number
Please enter your Doubt
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
- 200 Questions with Detailed Solutions
- Section-wise Coverage (GA, English, Quant & Reasoning)