Question
In the wait-die deadlock prevention scheme, transaction T1 has timestamp 5 and T2 has timestamp 10. If T2 requests a lock on a data item currently held by T1, what happens?
More IT DBMS Questions
- MVCC (Multi-Version Concurrency Control) ensures:
- Given relations Enrolled(Student, Course) and AllCourses(Course), which relational algebra operation correctly finds students enrolled in ALL courses liste...
- Which of the following best describes the control flow when a method in a subclass overrides a method in its superclass, and an object of the subclass is r...
- Which property of a database transaction ensures that its committed changes remain permanent even after a system failure?
- A table Orders(order_id, customer_id, order_date, amount) needs a query that returns each order alongside a running cumulative total of that customer's ord...
- What is a page fault?
- 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-P...
- R(A,B,C) is decomposed into R1(A,B) and R2(B,C). Which condition is sufficient in the standard binary lossless-join test?
- Deadlock occurs when:
- In DBMS concurrency control, a 'wait-for graph' is constructed with transactions as nodes and directed edges representing which transaction is waiting for ...
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)