Concurrency Control and Locking Protocols
Curriculum and historical examination lineage for Concurrency Control and Locking Protocols under Unit 5 (Transaction Management, Concurrency Control and Storage) of Database Management Systems (21CSC205P) at SRMIST.
Historical appearance distribution across SRMIST Formative Tests (CT1, CT2) and University End Semester examinations.
Factual marks weightage of questions asked on this topic in historical examinations.
Representative historical questions extracted directly from SRMIST examination papers.
Wait-die is a (A) Time stamp based dead lock (B) Dead lock update mechanism prevention mechanism (C) Buffer management mechanism (D) Task management mechanism [1]
In two phase locking protocol a transaction can release locks but it cannot acquire any new locks in this phase. (A) Shrinking (B) Growing (C) Time stamp (D) Serial [1]
Explain the two phase locking protocol and define how does it provide solutions to concurrency related problems. [12]
Examinations where questions for Concurrency Control and Locking Protocols have appeared.
Master Concurrency Control and Locking Protocols in MintAI
Practice past exam questions, test recurring archetypes, and view predictive probability for this topic before your upcoming exam.