Distributed database systems solved MCQ - Why deadlock handling is simple under single lock manager approach

Multiple choices questions in Distributed database, single lock manager concurrency control in distributed database, What is single lock manager approach? why deadlock handling is simple under single lock manager approach? How does single lock manager approach work?

Distributed database solved MCQ - Why deadlock handling is simple under single lock manager concurrency control protocol in distributed transactions

< Previous

Next >

 

1. Single lock manager approach is a concurrency control mechanism used in distributed database environment. Which of the following is an advantage of the above approach?

(a) Lock manager site is not vulnerable to failure

(b) Handling the deadlock is simple

(c) Implementation of the approach requires multiple messages handling for single transaction

(d) Lock manager site prone to bottleneck

Answer: (b) Handling the deadlock is simple What is single lock manager approach for concurrency control in DDB? As per this approach, the distributed database system maintains a single lock manager at a chosen site S. In distributed database, a transaction can be initiated at any site (server) that is part of the distributed database. Whenever a transaction requires locking a data item, it has to send the lock request to the lock manager site S. Based on the availability of the requested data item, S can grant or delay the lock permission.   Why deadlock handling is simple in single lock manager approach? Deadlocks are possible under lock based concurrency control mechanisms. They can be detected using Wait-for-graph in a centralized database system. Deadlock handling by single lock manager based concurrency control mechanism in distributed database is almost equivalent to that of centralized database system. Hence, handling of deadlock is simple.   Deadlock handling under Single lock manager concurrency control mechanism is simple than that of Distributed lock manager.

distributed lock manager

 

< Previous

Next >

******************

Related links:

• Go to Distributed Database Quiz page

• Go to Database Management Systems Quiz page

• Go to Distributed Database Home page

 

Distributed database multiple choice questions with answers

important quiz questions in DDB

What is the role of single lock manager approach in distributed database

Why deadlock handling is simple under single lock manager than distributed lock manager approach

Advantages of single lock manager approach in distributed database concurrency conltrol

Who initiates the concurrent execution of distributed transactions as per two phase commit protocol?

Transaction coordinator initiates the execution of concurrent distributed transactions