Basics Of Data Base Management System (KOE067) - AKTU Question Paper 2021-22
B.Tech · Semester 6 · Free PDF Download
This is the official AKTU Basics Of Data Base Management System Previous Year Question Paper for B.Tech Semester 6, 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 6
Session:2021-22
University:AKTU / UPTU
Rate this paper
Questions Asked in 2021-22
Basics Of Data Base Management System (KOE067) — complete question paper
Section AAttempt all q u e s t i o n s i n b r i e f . 2*10 = 20
- aDefineDatabase Management System(DBMS). 2 1
- bBriefly discuss about the differences between Database Syst em and File System
- dDiscuss about the Logical data Independence. 2 2
- eBriefly discuss about the n eed of Structured Query Language (SQL). 2 3
- fWhat do you mean by views and indexes in Structured Query Language (SQL)?
- gWhat is the use of Serializabilty? 2 4
- hDefine properties of Transaction. 2 4 (i) What do you understand by the D atabase Security? 2 5 (j) Discuss about the need of Backup and Recovery. 2 5
Section BAttempt any three o f t h e f o l l o w i n g : 10*3 = 30
- aExplain in detail about the application of Centralized and Client-Server Architectures
- bWrite short notes on any two of the following: (i) Relational Database Schema. (ii) Integrity constraints. (iii) Entity integrity
- cWhat do you mean by Transaction? Explain transaction proper ty with detail using the suitable example
- dWhat is Log? How is it maintained? Discuss the features of deferred database modification and immediate database modification in brief
- eDescribe theprinciples of Vi ews of data. Discuss about the levels of abstraction
Section CAttempt any one p a r t o f t h e f o l l o w i n g : 10*1 = 10
- aWhat is the need of Database Normalization? Discuss about t he First and Second Normal form with the help of an example
- bExplain about the Two phase Locking (2PL)? Describe with th e help of example
- aDiscuss about the concept of Data Modeling using the Entity Relationship (ER) Model
- bDiscuss about theuse of insert, update and delete operation s in Structured Query Language (SQL)
- aDiscuss in detail about the basic principle of Referential integrity and domain constraints in Relational Database
- bExplain in detail about any two of the following. (i) Data Mining. (ii) Data Warehousing. (ii) Data Visualization
- aDescribe the concept of Functional dependencies. What do yo u understand by Keys constraints and Domain constraints?
- bWrite down about any t wo of the following. (i) Stored procedures (ii) Stored function (iii) Database triggers
- aBriefly discuss any two of thefollowing through an example. (i) Super key (ii) Candidate key (iii) Primary key
- bWrite down about the concept of Recovery with Concurrent Transaction
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.
Basics Of Data Base Management System — Other Year Papers
AKTU Basics Of Data Base Management System PYQs from other sessions
More B.Tech Semester 6 (2021-22) Papers
Other subjects from same semester and session
Machine Design2021-22Repair And Rehabilitation Of Structures2021-22Idea To Business Model2021-22Control System2021-22Control System2021-22Microcontroller Embedded System Design2021-22Software Engineering2021-22Automotive Electrical And Electronics2021-22
View all B.Tech Semester 6 2021-22 papers →Syllabus & More PYQs
Paper solve karne se pehle unit-wise syllabus dekh lo