Sunday, January 16, 2022

DBMS Solved MCQ - Concurrency control protocol avoids cascading rollback

Multiple choices questions in DBMS, Concurrency control mechanism, Why incomplete transactions should not visible to other transactions in RDBMS? What is cascading rollback? Why cascading rollback is not possible under strict 2PL? How cascading rollback is avoided by rigorous two phase locking protocol?

DBMS MCQ - Concurrency control protocol avoids cascading rollback

< Previous                      

Next >

 

1. Which of the following concurrency control protocol can avoid cascading rollback?

a) Simple 2 Phase Locking protocol

b) Strict 2 Phase Locking protocol

c) Rigorous 2 Phase Locking protocol

d) Timestamp ordering protocol

Answer: (b) Strict 2 Phase Locking protocol and (c) Rigorous 2 Phase Locking protocol

Transactions that use either strict or rigorous 2PL protocols delay releasing the EXCLUSIVE locks on their data items until the transaction commits. Hence, other concurrent transactions cannot consume the data items that were modified by the transactions under strict or rigorous 2PL until the later release the locks.

What is cascading rollback and how is it caused?

If a transaction consumes the data item that was written by an uncommitted transaction, it may lead to cascading rollback, in case if the uncommitted transaction is decided to abort.

Example: Suppose T1 and T2 are two concurrent transactions. If T1 writes a data item A and T1 not yet committed. Now, T2 reads the value of A which was just modified by T1. This is uncommitted read / dirty read. At this time, if for some reason T1 decides to rollback or abort. This forces T2 to rollback because, T2 used the data produced by T1.

 

 


< Previous                      

Next >


************************
Related posts:


When to release EXCLUSIVE locks to avoid cascading rollback? 

Why strict and rigorous 2PL protocols avoid cascading rollback? 

How to avoid cascading rollback during execution of concurrent transactions? 

Strict and rigorous two phase locking protocol uses

Can we permit multiple transactions to execute in parallel?

DBMS Solved MCQ, Database management system solved mcq, transaction management system solved mcq, transaction states solved mcq, transaction mcq

Blogger Widgets

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

MageNet Ad

data recovery