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) — extracted question text
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. Check the original PDF for equations, diagrams and complete wording. Extracted: 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