Showing posts with label Concurrency Control. Show all posts
Showing posts with label Concurrency Control. Show all posts

Thursday, March 10, 2022

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:

 

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

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents

data recovery