B.TechSemester 52021-22Database Management SystemKCS-501
View PDFDownload

Database Management System (KCS-501) - AKTU Question Paper 2021-22

B.Tech · Semester 5 · Free PDF Download

This is the official AKTU Database Management System Previous Year Question Paper for B.Tech Semester 5, academic session 2021-22. 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:2021-22
University:AKTU / UPTU

Rate this paper

Questions Asked in 2021-22

Database Management System (KCS-501) — complete question paper

Section AAttempt all q u e s t i o n s i n b r i e f . 2 x 10 = 20
  • a
    What is the significance of Physical Data Independence?
  • b
    List the four functions of DBA
  • c
    When a relation set is calle d a recursive relationship set?
  • d
    What do you mean by currency with respect to database?
  • e
    What is Relational Calculus?
  • f
    What is Equi-Join in database?
  • g
    What is a CLAUSE in terms of SQL?
  • h
    Define the closure of an attribute set. i. When is a transaction Rolled Back? j. List the various levels of locking?
Section BAttempt any three o f t h e f o l l o w i n g : 10 x 3 = 30
  • a
    Draw the overall structure of DBMS and explain its various components
  • b
    Which relational algebra opera tions require the participating tables to be union- compatible? Give the Reason in detail
  • c
    What do you understand by transitive dependencies? Explain wi th an example any two problems that can arise in the database if transitive d ependencies are present in the database
  • d
    List ACID properties of transact ion. Explain the usefulness of each. What is the importance of log?
  • e
    What do you mean by time stamping protocol for concurrency con trolling? Discuss multi version scheme of concurrency control
Section CAttempt any one p a r t o f t h e f o l l o w i n g : 10 x 1 = 10
  • a
    What are the different types of Data Models in DBMS? Explain them
  • b
    State the procedural DML and nonprocedural DML with their differences
  • a
    Consider the following schema for institute library: Student (RollNo, Name, Father_ Name, Branch) Book (ISBN, Title, Author, Publisher) Issue (RollNo, ISBN, Date-of –Issue) Write the following queries in SQL and relational algebra: I. List roll number and name of a ll students of the branch ‘CSE’. II. Find the name of student w ho has issued a book published by ‘ABC’ publisher. III. List title of all books and their authors issued to a stud ent ‘RAM’. IV. List title of all books i ssued on or before December 1, 2020. V. List all books published by publisher ‘ABC’
  • b
    What do you mean by trigger? Exp lain it by a suitable example
  • a
    Describe Armstrong’s axioms in detail. What is the role of these rules in database development process?
  • b
    Describe the term MVD in the context of DBMS by giving an example. Discuss 4NF and 5NF also
  • a
    Describe serializable schedule. Discuss conflict serializab ility with suitable example
  • b
    Discuss the procedure of d eadlock detection and recovery in transaction?
  • a
    Given a schedule S for transactions T1 and T2 with set of r ead and write operations, Identify, whether given schedule is equivalent to serial schedule or not?
  • b
    Discuss 2 phase commit (2PC) protocol and time stamp based protocol with suitable example. How the validation based protocols differ from 2PC?

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 — KCS-501

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

2x

What are the different types of Data Models in DBMS? Explain them

Appeared in: 2021-22 · 2022-23

2x

State the procedural DML and nonprocedural DML with their differences

Appeared in: 2021-22 · 2023-24

2x

Consider the following schema for institute library: Student (RollNo, Name, Father_ Name, Branch) Book (ISBN, Title, Author, Publisher) Issue (RollNo, ISBN, Date-of –Issue) Write the following queries in SQL and relational algebra: I. List roll number and name of a ll students of the branch ‘CSE’. II. Find the name of student w ho has issued a book published by ‘ABC’ publisher. III. List title of all books and their authors issued to a stud ent ‘RAM’. IV. List title of all books i ssued on or before December 1, 2020. V. List all books published by publisher ‘ABC’

Appeared in: 2021-22 · 2022-23

2x

Describe the term MVD in the context of DBMS by giving an example. Discuss 4NF and 5NF also

Appeared in: 2021-22 · 2023-24

2x

Discuss the procedure of d eadlock detection and recovery in transaction?

Appeared in: 2021-22 · 2023-24

2x

Discuss 2 phase commit (2PC) protocol and time stamp based protocol with suitable example. How the validation based protocols differ from 2PC?

Appeared in: 2021-22 · 2023-24

Database Management System — Other Year Papers

AKTU Database Management System PYQs from other sessions

Database Management System2022-23Database Management System2024-25Database Management System2025-26

More B.Tech Semester 5 (2021-22) Papers

Other subjects from same semester and session

Advance Welding2021-22Ic Engine Fuel And Lubrication2021-22Application Of Soft Computing2021-22Optical Communication2021-22Web Technology2021-22Vlsi Technology2021-22Heat And Mass Transfer2021-22Compiler Design2021-22
View all B.Tech Semester 5 2021-22 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