Scribd
Upload
16 views1 page

DBMS Assignment5

Uploaded by

akashjais1187
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
16 views1 page

DBMS Assignment5

Uploaded by

akashjais1187
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

KIPM – College of Engineering &Technology

(Approved by AICTE, New Delhi & Affiliated to Dr. A. P. J. Abdul Kalam University, Lucknow)
Department of Computer Science and Engineering
Assignment- 5

Branch : Computer Science and Engineering/ CSE AIML


Subject Name : Database Management System
Subject Code : BCS 501
Year/ Semester : 3rd Year/ Vth Semester
Faculty Name : Mr. Vivek Patel
Session : 2024-25

Q. 1- Why concurrency control is needed?

Q. 2- Explain concurrency control mechanism perform with distributed database.

Q. 3- Explain different types of locks?

Q. 4- What do you understand by lock compatibility? Explain with example.

Q. 5- Write lock-based protocol?

Q. 6- Explain two phase locking protocol with suitable example.

Q. 7- Define time stamp-based protocol to maintain serializability in concurrent execution?

Q. 8- What is Thomas write rule?

Q. 9- Explain phantom phenomenon with suitable example?

Q. 10- What is multiple granularity protocol of concurrency control?

You might also like