Department of Information Technology
B. Tech. [SEM V (IT)]
IMPORTANT QUESTION SHEET-5
(Session: 2024-25)
BCS-501:Database Management System
Unit No. & Name: 5- Concurrency Control Course Outcome: CO1:Apply knowledge of
Techniques database for real life
applications.
Date of Distribution: 16/12/2024 Name of Faculty: Ankit Singh
Subjective Questions
Concurrency Control
Q1) Why is concurrency control needed ?
Q2) Define locks and mode of locks
Q3) Give merits and demerits of two-phase locking.
Locking Technique for Concurrency Control
Q4) Define upgrade and downgrade in locking protocol.
Q5) Define exclusive lock.
Timestamp Protocol
Q6) Define timestamp.
Q7) Define multiversion scheme.
Graph based Protocol and Two phase locking technique
Q8) Write the salient features of graph based locking protocol with suitable examples
Q9) Describe Two phase locking technique for Concurrency Control
Two phase commit ( protocol , ordering )
Q10) Explain the lost update problem , The dirty Read Problem and incorrect summary problem
Q11) Explain timestamp based protocol and timestamp ordering protocol
Q12) Discuss two phase commit Protocol
SUPPLEMENTARY QUESTIONS
Granularity
Q1) Discuss Thomas Write Rule
Q2) Explain validation protocol and multiple granularities in transaction system.
REFERENCES
Page 1 of 2
TEXT BOOKS:
Ref. [ID] Authors Book Title Publisher/Press Edition &Year of
Publication
Abraham Silberscatz ,
[T1] Database System Concept McGraw-Hill Education 7th Edition 2019
Henry F Korth
Ramez Elmasri , Shamkant
[T2] Fundamentals of Database Systems Pearson Education 8th Edition 2003
B .Navathe
REFERENCE BOOKS:
Edition &Year of
Ref. [ID] Authors Book Title Publisher/Press
Publication
Raghu Ramakrisnan ,
[R1] Johannes Database Management System McGraw-Hill Education 3rd Edition 2014
ONLINE/DIGITALREFERENCES:
Ref. [ID] Source Name Source Hyperlink
[D1] GeeksforGeeks-DBMS [Link]
…………………. X………………….
Signature of Faculty: ______________ Signature of HOD: _______________
(With Date) (With Date)
Page 2 of 2
