Database Management System Unit 5 – Concurrency Control Techniques: AKTU previous year questions
18 AKTU questions from Unit 5 (Concurrency Control Techniques) asked in 2021–2026, tagged by marks, year and topic. In short: about 23 marks of every paper come from this unit; the most asked topic is Locking Techniques Concurrency (5 times); 8 questions came back in a later year. The latest ones are listed below; on the page you can filter them by 2-mark or long questions, topic and repeats.
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)
- Discuss Concurrency control. Why it is needed in DBMS? Also explain timestamp based ordering in Concurrency control. (7 marks, 2025, Timestamp Protocols Concurrency)
- Explore the following (i) Multi version protocol (ii) Validation based protocol (7 marks, 2025, Multiple Granularity Multi Version)
- Discuss Conservative 2PL and Strict 2PL. (2 marks, 2023, Locking Techniques Concurrency)
- Discuss the timestamp ordering protocol for concurrency control. How does strict timestamp ordering differ from basic timestamp ordering? (10 marks, 2023, Timestamp Protocols Concurrency)
- How do optimistic concurrency control techniques differ from other concurrency control techniques? Why they are also called validation or certification techniques? Discuss the typical phases of an optimistic concurrency control method. (10 marks, 2023, Validation Based Protocol)
- List the various levels of locking? (2 marks, 2022, Locking Techniques Concurrency)
- What do you mean by time stamping protocol for concurrency controlling? Discuss multi version scheme of concurrency control. (10 marks, 2022, Timestamp Protocols Concurrency)
Most asked Unit 5 topics
- Locking Techniques Concurrency – asked 5 times
- Timestamp Protocols Concurrency – asked 5 times
- Validation Based Protocol – asked 3 times
Unit 5 question pattern
- 2-mark questions: 6 asked in 2021–2026
- 7-mark questions: 5 asked in 2021–2026
- 10-mark questions: 7 asked in 2021–2026
- About 23 marks from Unit 5 in every paper
- 8 questions were asked again in a later year
Unit 5 questions year by year
- 2026: 4 Unit 5 questions asked (23 marks across that year's papers)
- 2025: 3 Unit 5 questions asked (16 marks across that year's papers)
- 2023: 3 Unit 5 questions asked (22 marks across that year's papers)
- 2022: 3 Unit 5 questions asked (22 marks across that year's papers)
- 2021: 5 Unit 5 questions asked (34 marks across that year's papers)