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
- Which of the following is a type of phishing attack?
- A designer wants to remove a transitive dependency of a non-key attribute on a candidate key. Which normal form directly addresses this?
- What is a 'transaction' in DBMS and what does 'COMMIT' do?
- Relation R(A, B, C) has functional dependencies A→B and B→C, with A as the only candidate key. Is R in BCNF?
- Which of the following is a transaction property ensuring all steps are completed or none?
- Relation R has 20 tuples and relation S has 15 tuples, with no common attributes between them. What is the cardinality (number of resulting tuples) of R x ...
- Which of the following matches the definition given below: It is an artificial key that aims to uniquely identify each record.
- What does the acronym ACID stand for in the context of database transaction management?
- Which type of SQL JOIN returns all records from both tables, filling unmatched fields with NULL?
- Which of the following is an example of a NoSQL database?
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)