Database Management System PYQ 2025-26 AKTU Question Paper

AKTU · BTECH · Semester 5 · Database Management System · Session 2025-26 · PYQ

AKTU Database Management System previous year question paper 2025-26 for B.Tech Semester 5. Covers Introduction and ER Model, Relational Model and SQL…

Open the interactive reader to study this resource on AcademicArk.

Database Management System AKTU syllabus

  1. Unit 1: Introduction and ER Model
  2. Unit 2: Relational Model and SQL
  3. Unit 3: Database Design and Normalization
  4. Unit 4: Transaction Processing and Distributed DB
  5. Unit 5: Concurrency Control Techniques

Questions in Database Management System AKTU PYQ 2025-26

  1. Q1a. Explain Logical data Independence. (2 marks, 2025-26)
  2. Q1b. Write Advantages of Database. (2 marks, 2025-26)
  3. Q1c. Define Relational Algebra. (2 marks, 2025-26)
  4. Q1d. Define constraint and its types in DBMS. (2 marks, 2025-26)
  5. Q1e. Define 3 NF. (2 marks, 2025-26)
  6. Q1f. What is serializability in transaction processing systems? (2 marks, 2025-26)
  7. Q1g. Define Shared lock. (2 marks, 2025-26)
  8. Q2a. Discuss three level of abstractions or schemas architecture of DBMS. (7 marks, 2025-26)
  9. Q2b. Write difference between Cross Join, Natural Join, left outer join and right outer join with suitable example. (7 marks, 2025-26)
  10. Q2c. Consider R = (A, B, C, D, E, F, G, H) and F= { AB→ C, BC→ D, E → F, G → F, H → A, FG → H } Is the decomposition of R into R1(A, B, C, D), R2(A, B, C, E, F), R3(A, D, F, G, H) lossless? Is it dependency preserving? (7 marks, 2025-26)
  11. Q2d. Define Transaction. Explain transaction property with detail and suitable example. (7 marks, 2025-26)
  12. Q2e. Explain the Validation Based protocol for concurrency control. (7 marks, 2025-26)
  13. Q3a. Compare Generalization, Specialization and Aggregation with suitable examples. (7 marks, 2025-26)
  14. Q3b. Draw an ER diagram of Hospital or Bank with showing the Specialization, Aggregation, Generalization. Also convert it in to relational schemas and SQL DDL. (7 marks, 2025-26)
  15. Q4a. Consider the following relational DATABASE. Give an expression in SQL for each following queries Underline records are Primary Key Employee (person_name, street, city) Works (person_name, Company_name, salary) Company (Company_name, city) Manages (person_name, manager_name) a) Finds the names of… (7 marks, 2025-26)
  16. Q4b. Discuss the importance of domain constraints and key constraints in maintaining database consistency. Also explain Entity Integrity and Referential Integrity constraints with suitable examples. (7 marks, 2025-26)
  17. Q5a. Short Notes of the Following- i) MVD or JD ii) Normalization with advantages (7 marks, 2025-26)
  18. Q5b. Consider the universal relational schema R (A, B, C, D, E, F, G, H, I, J) and a set of following functional dependencies. F ={AB→C, A→DE, B→F, F →GH, D→IJ} Determine the keys for R? Decompose R into 2nd Normal Form. (7 marks, 2025-26)
  19. Q6a. 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);… (7 marks, 2025-26)
  20. Q6b. Explain in details about ACID properties of transaction. (7 marks, 2025-26)
  21. 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)
  22. 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

Database Management System previous year papers

More Database Management System resources

Browse all notes · Semester 5 notes · Database Management System notes