Database Management System Unit 5 – Concurrency Control Techniques: important questions for AKTU
Unit 5 (Concurrency Control Techniques) questions that AKTU repeats most often. This unit carries about 23 marks per paper. Start with the repeated questions, then the most asked topics.
Most repeated Unit 5 questions
- Discuss Concurrency control. Why it is needed in DBMS? Also explain timestamp based ordering in Concurrency control. (7 marks, 2025, Timestamp Protocols Concurrency) – also asked in 2021, 2022, 2023
- Discuss the timestamp ordering protocol for concurrency control. How does strict timestamp ordering differ from basic timestamp ordering? (10 marks, 2023, Timestamp Protocols Concurrency) – also asked in 2021, 2022, 2025
- What do you mean by time stamping protocol for concurrency controlling? Discuss multi version scheme of concurrency control. (10 marks, 2022, Timestamp Protocols Concurrency) – also asked in 2021, 2023, 2025
Most important Unit 5 topic
- Locking Techniques Concurrency (Unit 5: Concurrency Control Techniques) – asked 5 times in 2021, 2022, 2023, 2026
Most asked Unit 5 topics
- Locking Techniques Concurrency – asked 5 times
- Timestamp Protocols Concurrency – asked 5 times
- Validation Based Protocol – asked 3 times
More Unit 5 previous year questions
- Define Shared lock. (2 marks, 2026, Locking Techniques Concurrency)
- Explain the Validation Based protocol for concurrency control. (7 marks, 2026, Validation Based Protocol)
- Discuss the complexities of recovery with concurrent transactions. Also explain the importance of the checkpoints mechanism in reducing the time required for recovery after a system crash. (7 marks, 2026, Recovery with Concurrent Transactions)
- Describe major problems associated with concurrent processing with examples. What is the role of locks in avoiding these Problems. (7 marks, 2026, Locking Techniques Concurrency)
- Define multiple granuality. (2 marks, 2025, Multiple Granularity Multi Version)
Unit 5 syllabus topics
- Locking Techniques Concurrency
- Timestamp Protocols Concurrency
- Validation Based Protocol
- Multiple Granularity Multi Version
- Recovery with Concurrent Transactions
- Oracle Case Study