B.TechSemester 52023-24Data Base Management SystemKCS501
View PDFDownload

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.

Course:B.Tech
Semester:Semester 5
Session:2023-24
University:AKTU / UPTU

Rate this paper

Questions Asked in 2023-24

Data Base Management System (KCS501) — 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
  • a
    What is the concept of k eys in database? 2 1
  • b
    What is strong & weak entity set? 2 1
  • c
    Explain referentia l integrity. 2 2
  • d
    Explain entity integrity constraints. 2 2
  • e
    Write different inference rule for functional dependency? 2 3
  • f
    Why do we normalize database? 2 3
  • g
    What do you mean by testing of serializability? 2 4
  • h
    Define replication in dis tributed database. 2 4 i. Define concurrency control. 2 5 j. Define exclusive lock. 2 5
Section BAttempt any three o f t h e f o l l o w i n g :
  • a
    Discuss three level of abstractions or schemas architecture of DBMS. 10 1
  • b
    What is Aggregate function in SQL? Write SQL query for aggregate function. 10 2
  • c
    Describe the following terms : (i) Multivalued dependency (ii) Trigger 10 3
  • d
    Discuss the procedure of deadlock detection and recovery in transaction? 10 4
  • e
    Write the salient features of graph based locking protocol w ith suitable example. 10 5
Section CAttempt any one p a r t o f t h e f o l l o w i n g :
  • a
    State the procedural DML and nonprocedural DML with their differences. 10 1
  • b
    Discuss the role of database administrator & explain the database architecture. 10 1
  • a
    What 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
  • b
    Write difference between cross join, Natural join, left outer j oin and right outer join with suitable example. 10 2
  • a
    What is functional dependency? Explain the procedure of calculating the canonical cover of
  • a
    given functional dependency set with suitable example. 10 3
  • b
    Describe the term MVD in the context of DBMS by giving an examp le. Discuss 4NF and 5NF also. 10 3
  • a
    What is conflict serializable Schedule? Explain the difference between conflict and view serializable schedule using suitable example? 10 4
  • b
    What is Log? How is it maintained? Discuss the features of defe rred database modification and immediate database modification in brief. 10 4
  • a
    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
  • b
    What 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. Check the original PDF for equations, diagrams and complete wording. Extracted: 2026-08-23.

More B.Tech Semester 5 (2023-24) Papers

Other subjects from same semester and session

Electrical Standards And Engineering Practices2023-24Engineering Hydrology2023-24Web Designing2023-24Optical Communication2023-24Control System2023-24Computer Integrated Manufacturing2023-24Fuels And Combustion2023-24Electrical Machines Ii2023-24
View all B.Tech Semester 5 2023-24 papers →

Syllabus & More PYQs

Paper solve karne se pehle unit-wise syllabus dekh lo

📘 Database Management System — Unit-wise SyllabusBCS501AKTU 3rd Year SyllabusAKTU 3rd Year PYQs — All BranchesCSE 3rd Year SyllabusIT 3rd Year SyllabusCSE DS 3rd Year Syllabus