Home › AKTU PYQ › Database Management System › Important Questions

Database Management System (BCS501) important questions and topics for AKTU

These are ranked by how often AKTU repeats them across 5 papers. Repeated questions and "very likely" topics are the safest marks in the exam.

Most repeated Database Management System 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
  • Consider schedules S1, S2, and S3 below. Determine whether each schedule is strict, cascade less, recoverable, or non recoverable. (Determine the strictest recoverability condition that each schedule satisfies.) S1: r1(X); r2(Z); r1(Z); r3(X); r3(Y); w1(X); c1; w3(Y); c3; r2(Y); w2(Z); w2(Y); c2; S2: r1(X); r2(Z); r1(Z); r3(X); r3(Y); w1(X); w3(Y); r2(Y); w2(Z); w2(Y); c1;c2;c3; S3: r1(X); r2(Z); r3(X); r1(Z); r2(Y); r3(Y); w1(X); c1; w2(Z); w3(Y); w2(Y); c3;c2; (10 marks, 2023, Transaction Processing Concepts) – also asked in 2021, 2022, 2025, 2026
  • Describe serializable schedule. Discuss conflict serializability with suitable example. (10 marks, 2022, Transaction Processing Concepts) – also asked in 2021, 2023, 2025, 2026

High-probability Database Management System topics

  • Transaction Processing Concepts (Unit 4: Transaction Processing and Distributed DB) – asked 21 times in 2021, 2022, 2023, 2025, 2026
  • Data Model Schema Instances (Unit 1: Introduction and ER Model) – asked 9 times in 2021, 2022, 2023, 2025, 2026
  • Relational Data Model (Unit 2: Relational Model and SQL) – asked 9 times in 2021, 2022, 2023, 2025, 2026