MCASemester 22023-24Database Management SystemsKCA204

Database Management Systems (KCA204) - AKTU Question Paper 2023-24

MCA · Semester 2 · Free PDF Download

This is the official AKTU Database Management Systems Previous Year Question Paper for MCA Semester 2, academic session 2023-24. 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:2023-24

University:AKTU / UPTU

Rate this paper

Questions Asked in 2023-24

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

Section AAttempt all questions in brief. 2 x 10 = 20

a
What do you mean by logical data independence? 02 1
b
What do you mean by data integrity? 02 1
c
Define entity and entity set. Gi ve one example for illustration 02 2
d
Explain with suitable example: Stored & Derive Attribute. 02 2
e
Determine the Relational Alge bra expression for following- For a relation Employee(EID, Ename, city), find the name of employees who either live in Delhi or live in Mumbai
f
There is a table named EMP (ID, Name, DOJ). Write the sql quer y to display all the customer details. ( Note – Date of joining must be displayed in the format ‘07/December/2019’)
g
What will be the number of possible superkeys for the relation schema R(E,F,G,H) with EF as key ?
h
Consider a relation R (A, B, C, D, E) with following FD’s: Does B -> CD? Exists over the relation R? i. What do you mean by commit point of a transaction? 02 4 j. What do you mean by a serializable schedule? 02 5

Section BAttempt any three of the following: 3 x 10 = 30

a
Explain the advantages of data base systems over file-oriented system. 10 1
b
Consider the following scenario for a college database. 1. S tudents enroll for a course. 2. There are some departments. 3. Departments have faculty members. 4. Each department runs some courses. Draw an E-R diagram. Convert the E-R Diagram into relational model
c
What do you mean by Time Stamp ? Discuss time Stamp ordering protocol in detail
d
Consider a relation R (A, B, C, G, H, I) and set of function al dependencies F{A  B, A  C, CG  H, CG  I, B  H}. Is AG a super key for the relation R? Is AG a candidate ke
e
Write the reasons for a trans action failure. Explain the che ck point mechanism used to recover from a transaction failure

Section CAttempt any one part of the following: 1 x 10 = 10

a
With a neat diagram discuss th e three-level architecture of DBMS 10 1
b
Explain with example, how data redundancy leads to data inconsistency. 10 1
a
For a relation ClientMaster[C lient_No(Varchar, primary key), Name(Varchar, not null), Address1(Varchar), City(Varchar, default ‘Delhi’ ), Pincode(Number), Bal_Due(Float), find the SQL queries for following
1
Create the given relation
2
Add new field as state in the relation
3
Remove the city field from the relation
4
Remove the existence of ClientMaster relation
5
Rename clientMaster to Client _Master
b
A table named EMP(Empid, Name, DOB, Address, Passport_No, Lisence_No, SSN) is there. Find out the following: Alternative Keys, Non-key Attributes, Non-Prime attributes, Prime Attribute
a
Demonstrate inner-join and out er-join with suitable example. 10 2
b
How is a trigger different from procedure? Illustrate a trig ger which will insert the updated salary as well as the old salary of an employee into a table named emp_audit
a
What is transitive functiona l dependency? Explain how insert ion anamoly, updation anamoly and de letion anamoly occurs when a relation is having transitive functional dependency?
b
Define BCNF. Illustrate your a nswer with a suitable example. 10 3
a
What do you mean by concurrency? Demonstrate how 2 phase locking protocol can be useful for controlling the concurrency. Discuss t h e different variations of 2PL
b
What do you mean by deadlock prevention? Discuss the Wait-Di e and Wound-Wait deadlock prevention algorithm

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.

Repeated Questions — KCA204

Questions that appeared in more than one session, found by comparing 4 years of Database Management Systems papers (2021-22, 2022-23, 2023-24, 2024-25)

What do you mean by logical data independence? 02 1