Basics Of Database Management Systems (BOE407) - AKTU Question Paper 2025-26
B.Tech · Semester 4 · Free PDF Download
This is the official AKTU Basics Of Database Management Systems Previous Year Question Paper for B.Tech Semester 4, academic session 2025-26. Published by Dr. A.P.J. Abdul Kalam Technical University (AKTU/UPTU), Lucknow. Free PDF download — no login required.
Rate this paper
Questions Asked in 2025-26
Basics Of Database Management Systems (BOE407) — complete question paper · 70 marks · 3 Hours
- aWhat is data redundancy? Why should it be minimized? List the roles and responsibilities of a Database Administrator in a DBMS
- cDifferentiate between natural join and Cartesian product
- dDifferentiate between WHERE and HAVING
- eState the condition for a relation to be in 2NF
- fDefine trivial and non-trivial functional dependencies
- gWhat is serializability in DBMS?
- cΠA,F (σC = D(r × s)) (SEM. IV) THEORY EXAMINATION 2025-26 BASICS OF DATABASE MANAGEMENT SYSTEMS
- cΠA,F (σC = D(r × s))
- cExplain aggregate functions and grouping in SQL with examples. Discuss Third Normal Form (3NF). For relational schema R (A, B, C, D, E) with functional dependencies: A→B, BC→E, ED→A. Find the highest normal form of relation R. Discuss concurrency control in DBMS. Why is it required? Describe timestamp-based concurrency control methods
- ar1(X); r3(X); w3(X); w1(X); r2(X)
- br3(X); r2(X); w3(X); r1(X); w1(X)
- cr1(X); r3(X); w3(X); w1(X); r2(X)
- dr3(X); r2(X); w3(X); r1(X); w1(X)
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 Database Management Systems — Other Year Papers
AKTU Basics Of Database Management Systems PYQs from other sessions
More B.Tech Semester 4 (2025-26) Papers
Other subjects from same semester and session
Syllabus & More PYQs
Paper solve karne se pehle unit-wise syllabus dekh lo