Data Base Management System (KCS501) - AKTU Question Paper 2023-24
B.Tech · Semester 5 · Free PDF Download
This is the official AKTU Data Base Management System Previous Year Question Paper for B.Tech Semester 5, academic session 2023-24. Published by Dr. A.P.J. Abdul Kalam Technical University (AKTU/UPTU), Lucknow. Free PDF download — no login required.
Rate this paper
Questions Asked in 2023-24
Data Base Management System (KCS501) — complete question paper · 100 marks · 3 Hours
- aWhat is the concept of k eys in database? 2 1
- bWhat is strong & weak entity set? 2 1
- cExplain referentia l integrity. 2 2
- dExplain entity integrity constraints. 2 2
- eWrite different inference rule for functional dependency? 2 3
- fWhy do we normalize database? 2 3
- gWhat do you mean by testing of serializability? 2 4
- hDefine replication in dis tributed database. 2 4 i. Define concurrency control. 2 5 j. Define exclusive lock. 2 5
- aDiscuss three level of abstractions or schemas architecture of DBMS. 10 1
- bWhat is Aggregate function in SQL? Write SQL query for aggregate function. 10 2
- cDescribe the following terms : (i) Multivalued dependency (ii) Trigger 10 3
- dDiscuss the procedure of deadlock detection and recovery in transaction? 10 4
- eWrite the salient features of graph based locking protocol w ith suitable example. 10 5
- aState the procedural DML and nonprocedural DML with their differences. 10 1
- bDiscuss the role of database administrator & explain the database architecture. 10 1
- aWhat is ER Diagram? Explain different components of an ER Diagr a m w i t h e m p l o y e e project Management system. 10 2
- bWrite difference between cross join, Natural join, left outer j oin and right outer join with suitable example. 10 2
- aWhat is functional dependency? Explain the procedure of calculating the canonical cover of
- agiven functional dependency set with suitable example. 10 3
- bDescribe the term MVD in the context of DBMS by giving an examp le. Discuss 4NF and 5NF also. 10 3
- aWhat is conflict serializable Schedule? Explain the difference between conflict and view serializable schedule using suitable example? 10 4
- bWhat is Log? How is it maintained? Discuss the features of defe rred database modification and immediate database modification in brief. 10 4
- aDiscuss 2 phase commit (2PC) protocol and time stamp-based prot ocol with suitable example. How the validation-based protocols differ from 2PC? 10 5
- bWhat are multi version schemes of concurrency control? Describe with the help of an example. Discuss the various Time stamping protocols for concurrency control also. 10 5
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 — KCS501
Questions that appeared in more than one session, found by comparing 3 years of Data Base Management System papers (2021-22, 2022-23, 2023-24)
Discuss the procedure of deadlock detection and recovery in transaction? 10 4
Appeared in: 2021-22 · 2023-24
State the procedural DML and nonprocedural DML with their differences. 10 1
Appeared in: 2021-22 · 2023-24
Describe the term MVD in the context of DBMS by giving an examp le. Discuss 4NF and 5NF also. 10 3
Appeared in: 2021-22 · 2023-24
Discuss 2 phase commit (2PC) protocol and time stamp-based prot ocol with suitable example. How the validation-based protocols differ from 2PC? 10 5
Appeared in: 2021-22 · 2023-24
More B.Tech Semester 5 (2023-24) Papers
Other subjects from same semester and session
Syllabus & More PYQs
Paper solve karne se pehle unit-wise syllabus dekh lo