B.TechSemester 42025-26Basics Of Database Management SystemsBOE407
View PDFDownload

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.

Course:B.Tech
Semester:Semester 4
Session:2025-26
University:AKTU / UPTU

Rate this paper

Questions Asked in 2025-26

Basics Of Database Management Systems (BOE407) — extracted question text · 70 marks · 3 Hours

Section AAttempt all questions in brief. 02 x 7 = 14
  • a
    What is data redundancy? Why should it be minimized? List the roles and responsibilities of a Database Administrator in a DBMS
  • c
    Differentiate between natural join and Cartesian product
  • d
    Differentiate between WHERE and HAVING
  • e
    State the condition for a relation to be in 2NF
  • f
    Define trivial and non-trivial functional dependencies
  • g
    What is serializability in DBMS?
Section BAttempt any three of the following: 07 x 3 = 21
  • 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))
  • c
    Explain 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
Section CAttempt any one part of the following: 07 x 1 = 07
  • a
    r1(X); r3(X); w3(X); w1(X); r2(X)
  • b
    r3(X); r2(X); w3(X); r1(X); w1(X)
  • c
    r1(X); r3(X); w3(X); w1(X); r2(X)
  • d
    r3(X); r2(X); w3(X); r1(X); w1(X)

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 Database Management Systems — Other Year Papers

AKTU Basics Of Database Management Systems PYQs from other sessions

Basics Of Database Management Systems2023-24Basics Of Database Management Systems2024-25Basics Of Database Management Systems2023-24Basics Of Database Management Systems2024-25

More B.Tech Semester 4 (2025-26) Papers

Other subjects from same semester and session

Technical Communication2025-26Mathematics Iii2025-26Mathematics Iv2025-26Mathematics V2025-26Cyber Security2025-26Python Programming2025-26Operating System2025-26Theory Of Automata And Formal Languages2025-26
View all B.Tech Semester 4 2025-26 papers →

Syllabus & More PYQs

Paper solve karne se pehle unit-wise syllabus dekh lo

AKTU 2nd Year PYQs — All Branches