Database Management System Unit 4 Notes AKTU (BCS501)

AKTU · BTECH · Semester 5 · Database Management System · Unit 4 · Notes

AKTU Database Management System (BCS501) Unit 4 notes for B.Tech Semester 5 – Transaction Processing and Distributed DB. Topics: Transaction Processing…

A preview is available. Sign in or check access options in the reader for the complete resource.

Unit 4: Transaction Processing and Distributed DB – AKTU syllabus topics

  • Transaction Processing Concepts: Serializability of Schedules, Conflict and View Serializable, Recoverability Transaction Recovery
  • Log Based Recovery Checkpoints
  • Deadlock Handling
  • Distributed Database: Distributed Data Storage, Concurrency Control Directory

Most asked AKTU PYQ questions from Unit 4

  1. Q6a. 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;… (10 marks, 2022-23)
  2. Q6b. Consider the three transactions T1, T2, and T3, and the schedules S1 and S2 given below. 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);… (10 marks, 2022-23)
  3. Q6a. Describe serializable schedule. Discuss conflict serializability with suitable example. (10 marks, 2021-22)
  4. Q2d. Explain the method of testing the serializability. Consider the schedule S1 and S2 given below S1: R1(A),R2(B),W1(A),W2(B) S2: R2(B),R1(A),W2(B), W1(A) Check whether the given schedules are conflict equivalent or not? (10 marks, 2020-21)
  5. Q6a. What is Conflict Serializable Schedule? Check the given Schedule S1 is Conflict Serializable or not? S1: R1(X), R2(X),R2(Y),W2(Y),R1(Y),W1(X) (10 marks, 2020-21)
  6. Q6b. Explain in details about ACID properties of transaction. (7 marks, 2025-26)
  7. Q6a. 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, 2024-25)
  8. Q1g. Discuss Consistency and Isolation property of a transaction. (2 marks, 2022-23)
  9. Q1g. What are ACID properties of Transaction? (2 marks, 2020-21)
  10. Q2d. List ACID properties of transaction. Explain the usefulness of each. What is the importance of log? (10 marks, 2021-22)

AKTU paper codes: BCS501, KCS501, RCS501

Other Database Management System units

Database Management System previous year papers

More Database Management System resources

More versions of this resource

Browse all notes · Semester 5 notes