What is concurrency control? Name various methods of controlling the concurrency control? Differentiate between Binary lock and shared/Exclusive lock.
Marks: 10Chapter: Unit 9: Concurrency Control Techniques (4 Hrs.)
Chapter Study
Bsc CSIT Semester 4 – Database Management System – Unit 9: Concurrency Control Techniques (4 Hrs.)
Comprehensive questions and detailed answers for Unit 9: Concurrency Control Techniques (4 Hrs.). Perfect for exam preparation and concept clarity.
10
Questions
70
Marks
What is concurrency control? Name various methods of controlling the concurrency control? Differentiate between Binary lock and shared/Exclusive lock.
HardTHEORY10 marks2076(TU Final)
What is Granularity of data items? How does it effect in concurrency control?
MediumTHEORY5 marks2076(TU Final)
Explain 2 phase locking technique in brief.
MediumTHEORY5 marks2076(TU Final)
Explain deadlock and starvation. Explain Time stamp based protocol for concurrency control?
HardTHEORY10 marks2078(TU Final)
What is concurrency control? What are its advantages in DBMS?
MediumTHEORY5 marks2079(TU Final)
What is two-phase locking? What are different types of locks in two-phase locking? Explain basic, conservative, strict, rigorous two-phase locking. What is lock conversion?
HardTHEORY10 marks2080(TU Final)
Why do we need concurrency control in databses? Explain.
MediumTHEORY5 marks2080(TU Final)
Explain deadlock with example. What are different deadlock prevention protocols? Explain deadlock detection and starvation.
HardTHEORY10 marks2080(TU Final)
How timestamp ordering protocol is used for ensuring concurrency control?
MediumTHEORY5 marks2080(TU Final)
Explain transaction deadlock with example.
MediumTHEORY5 marks2081(TU Final)
Showing 10 questions
Sample Questions
What is Granularity of data items? How does it effect in concurrency control?
Marks: 5Chapter: Unit 9: Concurrency Control Techniques (4 Hrs.)
Explain 2 phase locking technique in brief.
Marks: 5Chapter: Unit 9: Concurrency Control Techniques (4 Hrs.)
Explain deadlock and starvation. Explain Time stamp based protocol for concurrency control?
Marks: 10Chapter: Unit 9: Concurrency Control Techniques (4 Hrs.)
What is concurrency control? What are its advantages in DBMS?
Marks: 5Chapter: Unit 9: Concurrency Control Techniques (4 Hrs.)
And more questions available on this page.