Database Management Systems (DBMS)
What is the name for a situation in which two transactions are each waiting for the other to release a lock, preventing progress?
Difficulty: Hard
About this MCQ
This Hard Database Management Systems (DBMS) MCQ checks one syllabus fact.
The question is: “What is the name for a situation in which two transactions are each waiting for the other to release a lock, preventing progress?”
The accepted answer is D. Transaction deadlock. Transaction deadlock is the fact required by What is the name for a situation in which two transactions are each waiting for the other to release a lock preventing progress option D Option A Transaction does not match the stem it is a near-miss used to catch incomplete recall of Transaction deadlock Option B Database trigger does not match the stem it is a near-miss used to catch incomplete recall of Transaction deadlock Remaining alternatives Database index fall outside the same rule and should be eliminated once Transaction deadlock is identified Database Management Systems DBMS questions of this type reward precise definitions rather than approximate associations Database Management Systems DBMS recall of this distinction is a regular item in FPSC.
- A. Transaction
Why not A: “Transaction” is not correct. The accepted answer is D. Transaction deadlock. Transaction deadlock is the fact required by What is the name for a situation in which two transactions are each waiting for the other to release a lock preventing progress option
- B. Database trigger
Why not B: “Database trigger” is not correct. The accepted answer is D. Transaction deadlock. Transaction deadlock is the fact required by What is the name for a situation in which two transactions are each waiting for the other to release a lock preventing progress option
- C. Database index
Why not C: “Database index” is not correct. The accepted answer is D. Transaction deadlock. Transaction deadlock is the fact required by What is the name for a situation in which two transactions are each waiting for the other to release a lock preventing progress option
- D. Transaction deadlock ✓
Correct answer
D. Transaction deadlock
Explanation
Transaction deadlock is the fact required by What is the name for a situation in which two transactions are each waiting for the other to release a lock preventing progress option D Option A Transaction does not match the stem it is a near-miss used to catch incomplete recall of Transaction deadlock Option B Database trigger does not match the stem it is a near-miss used to catch incomplete recall of Transaction deadlock Remaining alternatives Database index fall outside the same rule and should be eliminated once Transaction deadlock is identified Database Management Systems DBMS questions of this type reward precise definitions rather than approximate associations Database Management Systems DBMS recall of this distinction is a regular item in FPSC.
Source: Database Management Systems (DBMS) Official Reference Guide
Tags: computer science, dbms, SQL, databases
Submitted by: MCQsHub Editorial
Related MCQs
- Which term refers to a virtual table based on the result of a stored SQL query?
- Identify the correct concept described as: a minimal set of attributes that can uniquely identify a record in...
- Select the accurate description of Database trigger.
- The following statement describes a specific concept. What is it called? a stored procedure that automatically...
- What is Denormalization primarily used for?
- Which concept is defined as follows: the process of intentionally introducing redundancy into a database to im...