MCASemester 22024-25Database Management SystemsKCA204
View PDFDownload

Database Management Systems (KCA204) - AKTU Question Paper 2024-25

MCA · Semester 2 · Free PDF Download

This is the official AKTU Database Management Systems Previous Year Question Paper for MCA Semester 2, academic session 2024-25. Published by Dr. A.P.J. Abdul Kalam Technical University (AKTU/UPTU), Lucknow. Free PDF download — no login required.

Course:MCA
Semester:Semester 2
Session:2024-25
University:AKTU / UPTU

Rate this paper

Questions Asked in 2024-25

Database Management Systems (KCA204) — complete question paper · 100 marks · 3 Hours

Section AAttempt all q u e s t i o n s i n b r i e f . 2 x 1 0 = 2 0
  • a
    What is a Database? How is it different from a File System?
  • b
    What is a Super Key? How is it different from a Candidate Key? 1 K 1
  • c
    What is Referential Integrity? Give an example
  • d
    Write the syntax and exampl e of a nested subquery
  • e
    Define Functional Dependency with an example
  • f
    What is the difference between 3NF and BCNF?
  • g
    Define a Transaction and its ACID properties
  • h
    What is the purpose of Checkpoints in DBMS? 4 K2 i. What is Concurrency Control? Why is it needed? 5 K1 j. Define Lock-based Protocol
Section BAttempt any three o f t h e f o l l o w i n g : 1 0 x 3 = 3 0
  • a
    Explain the three-level architecture of DBMS with a neat dia gram
  • b
    Describe basic Relational Alge bra operations with examples
  • c
    Explain the process of Normalization up to BCNF with suitabl e examples
  • d
    Explain the concept of Serializability with examples of seri al and non-serial schedules
  • e
    Explain the Two-Phase Locking Protocol (2PL) and its variant s
Section CAttempt any one p a r t o f t h e f o l l o w i n g : 1 0 x 1 = 1 0
  • a
    Describe the ER Model. Draw an ER diagram for a hospital management system and convert it into tables
  • b
    Explain Generalization, Speci alization, and Aggregation with examples
  • a
    Write SQL queries to perform Insert, Update, Delete, and Joi n operations on Employee and Department tables
  • b
    Explain Tuple Relational Calc ulus and Domain Relational Calculus with examples
  • a
    Normalize the given relation up to 3NF: Student(RollNo, Name, Dept, Course, Instructor, Instructor_Phone)
  • b
    Discuss the various types of D ependencies: FD, MVD, and JD
  • a
    What is a Deadlock? Explain deadlock detection and prevention techniques
  • b
    Explain the architecture and characteristics of Distributed Databases
  • a
    Explain how Recovery is handled in case of concurrent transa ctions
  • b
    What is Multiple Granularity Locking? How does it improve co ncurrency?

Question text is extracted from the official AKTU question paper PDF above. Hindi translations are omitted — every question is printed in English in the original paper. Last verified: 2026-08-23.

Database Management Systems — Other Year Papers

AKTU Database Management Systems PYQs from other sessions

Database Management Systems2021-22Database Management Systems2022-23Database Management Systems2023-24Database Management Systems2024-25

More MCA Semester 2 (2024-25) Papers

Other subjects from same semester and session

Operating Systems2024-25Theory Of Automata Formal Languages2024-25Object Oriented Programming2024-25Data Structures Analysis Of Algorithms2024-25Web Technology2024-25Data Structures Analysis Of Algorithms2024-25Operating Systems2024-25Object Oriented Programming2024-25
View all MCA Semester 2 2024-25 papers →