Home › AKTU PYQ › Database Management System › Important Questions › Unit 4

Database Management System Unit 4 – Transaction Processing and Distributed DB: important questions for AKTU

Unit 4 (Transaction Processing and Distributed DB) questions that AKTU repeats most often. This unit carries about 35 marks per paper. Start with the repeated questions, then the most asked topics.

Most repeated Unit 4 questions

  • Consider the three transactions T1, T2, and T3, and the schedules S1 and S2 given below. Draw the serializability (precedence) graphs for S1 and S2 and state whether each schedule is serializable or not. If a schedule is serializable, write down the equivalent serial schedule(s). T1: r1(X); r1(Z); w1(X); T2: r2(Z); r2(Y); w2(Z); w2(Y); T3: r3(X); r3(Y); w3(Y); S1: r1(X); r2(Z); r1(Z); r3(X); r3(Y); w1(X); w3(Y); r2(Y); w2(Z); w2(Y); S2: r1(X); r2(Z); r3(X); r1(Z); r2(Y); r3(Y); w1(X); w2(Z); w3(Y); w2(Y); (7 marks, 2026, Transaction Processing Concepts) – also asked in 2021, 2022, 2023, 2025
  • Explain in details about ACID properties of transaction. (7 marks, 2026, Transaction Processing Concepts) – also asked in 2021, 2022, 2023, 2025
  • Illustrate Conflict Serializable Schedule. Check the given Schedule S1 is Conflict Serializable or not? Also check is it view Serializable? S1: R1(X), R2(X),R2(Y),W2(Y),R1(Y),W1(X) (7 marks, 2025, Transaction Processing Concepts) – also asked in 2021, 2022, 2023, 2026

Most important Unit 4 topic

  • Transaction Processing Concepts (Unit 4: Transaction Processing and Distributed DB) – asked 21 times in 2021, 2022, 2023, 2025, 2026

Most asked Unit 4 topics

  • Transaction Processing Concepts – asked 21 times
  • Deadlock Handling – asked 3 times
  • Log Based Recovery Checkpoints – asked 2 times

More Unit 4 previous year questions

  • What is serializability in transaction processing systems? (2 marks, 2026, Transaction Processing Concepts)
  • Define Transaction. Explain transaction property with detail and suitable example. (7 marks, 2026, Transaction Processing Concepts)
  • Explain properties of Transaction. (2 marks, 2025, Transaction Processing Concepts)
  • Determine different types of failures in case of transactions and how it can be recovered based on log file? Explain with suitable example. (7 marks, 2025, Log Based Recovery Checkpoints)
  • Explain schedule and transaction. Define the concepts of recoverable, cascade less, and strict schedules, and compare them in terms of their recoverability. (7 marks, 2025, Transaction Processing Concepts)

Unit 4 syllabus topics

  • Transaction Processing Concepts
  • Log Based Recovery Checkpoints
  • Deadlock Handling
  • Distributed Database