Database Management System Unit 5 Important Questions AKTU

AKTU · BTECH · Semester 5 · Database Management System · Unit 5 · Important Question

AKTU Database Management System (BCS501) Unit 5 important questions for B.Tech Semester 5 – Concurrency Control Techniques. Topics: Locking Techniques…

Open the interactive reader to study this resource on AcademicArk.

Unit 5: Concurrency Control Techniques – AKTU syllabus topics

  • Locking Techniques Concurrency
  • Timestamp Protocols Concurrency
  • Validation Based Protocol
  • Multiple Granularity Multi Version
  • Recovery with Concurrent Transactions
  • Oracle Case Study

Most asked AKTU PYQ questions from Unit 5

  1. Q7a. Discuss the timestamp ordering protocol for concurrency control. How does strict timestamp ordering differ from basic timestamp ordering? (10 marks, 2022-23)
  2. Q2e. What do you mean by time stamping protocol for concurrency controlling? Discuss multi version scheme of concurrency control. (10 marks, 2021-22)
  3. Q7a. Explain Time Stamp Based Concurrency Control technique. (10 marks, 2020-21)
  4. Q2e. Discuss Concurrency control. Why it is needed in DBMS? Also explain timestamp based ordering in Concurrency control. (7 marks, 2024-25)
  5. Q7b. 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, 2022-23)
  6. Q2e. Explain the Validation Based protocol for concurrency control. (10 marks, 2020-21)
  7. Q7b. Discuss 2 phase commit (2PC) protocol and time stamp based protocol with suitable example. How the validation based protocols differ from 2PC? (10 marks, 2021-22)
  8. Q7b. Explain Recovery from Concurrent Transaction. (10 marks, 2020-21)
  9. Q7a. 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, 2025-26)
  10. Q7b. Describe major problems associated with concurrent processing with examples. What is the role of locks in avoiding these Problems. (7 marks, 2025-26)

AKTU paper codes: BCS501, KCS501, RCS501

Other Database Management System units

Database Management System previous year papers

More Database Management System resources

Browse all notes · Semester 5 notes