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) — extracted question text · 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
- aWhat is a Database? How is it different from a File System?
- bWhat is a Super Key? How is it different from a Candidate Key? 1 K 1
- cWhat is Referential Integrity? Give an example
- dWrite the syntax and exampl e of a nested subquery
- eDefine Functional Dependency with an example
- fWhat is the difference between 3NF and BCNF?
- gDefine a Transaction and its ACID properties
- hWhat 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
- aExplain the three-level architecture of DBMS with a neat dia gram
- bDescribe basic Relational Alge bra operations with examples
- cExplain the process of Normalization up to BCNF with suitabl e examples
- dExplain the concept of Serializability with examples of seri al and non-serial schedules
- eExplain 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
- aDescribe the ER Model. Draw an ER diagram for a hospital management system and convert it into tables
- bExplain Generalization, Speci alization, and Aggregation with examples
- aWrite SQL queries to perform Insert, Update, Delete, and Joi n operations on Employee and Department tables
- bExplain Tuple Relational Calc ulus and Domain Relational Calculus with examples
- aNormalize the given relation up to 3NF: Student(RollNo, Name, Dept, Course, Instructor, Instructor_Phone)
- bDiscuss the various types of D ependencies: FD, MVD, and JD
- aWhat is a Deadlock? Explain deadlock detection and prevention techniques
- bExplain the architecture and characteristics of Distributed Databases
- aExplain how Recovery is handled in case of concurrent transa ctions
- bWhat is Multiple Granularity Locking? How does it improve co ncurrency?
Question text is extracted from the official AKTU question paper PDF above. Check the original PDF for equations, diagrams and complete wording. Extracted: 2026-08-23.
Database Management Systems — Other Year Papers
AKTU Database Management Systems PYQs from other sessions
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 →