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
3 · 1 rating
Questions Asked in 2021-22
Database Management System (KCS-501) — extracted question text
Section AAttempt all q u e s t i o n s i n b r i e f . 2 x 10 = 20
- aWhat is the significance of Physical Data Independence?
- bList the four functions of DBA
- cWhen a relation set is calle d a recursive relationship set?
- dWhat do you mean by currency with respect to database?
- eWhat is Relational Calculus?
- fWhat is Equi-Join in database?
- gWhat is a CLAUSE in terms of SQL?
- hDefine 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
- aDraw the overall structure of DBMS and explain its various components
- bWhich relational algebra opera tions require the participating tables to be union- compatible? Give the Reason in detail
- cWhat 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
- dList ACID properties of transact ion. Explain the usefulness of each. What is the importance of log?
- eWhat 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
- aWhat are the different types of Data Models in DBMS? Explain them
- bState the procedural DML and nonprocedural DML with their differences
- aConsider 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’
- bWhat do you mean by trigger? Exp lain it by a suitable example
- aDescribe Armstrong’s axioms in detail. What is the role of these rules in database development process?
- bDescribe the term MVD in the context of DBMS by giving an example. Discuss 4NF and 5NF also
- aDescribe serializable schedule. Discuss conflict serializab ility with suitable example
- bDiscuss the procedure of d eadlock detection and recovery in transaction?
- aGiven 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?
- bDiscuss 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. Check the original PDF for equations, diagrams and complete wording. Extracted: 2026-08-23.
Database Management System — Other Year Papers
AKTU Database Management System PYQs from other sessions
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