B.TechSemester 42023-24Basics Of Database Management SystemsBOE407
View PDFDownload

Basics Of Database Management Systems (BOE407) - AKTU Question Paper 2023-24

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 2023-24. 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:2023-24
University:AKTU / UPTU

Rate this paper

Questions Asked in 2023-24

Basics Of Database Management Systems (BOE407) — complete question paper · 70 marks · 3 Hours

Section AAttempt all q u e s t i o n s i n b r i e f . 2 x 7 = 14
  • a
    Differentiate between logical a nd physical data independence?
  • b
    Give an example of a schema in a relational database?
  • d
    What does the SELECT statement do in SQL?
  • e
    Name one characteristic of SQL as a language?
  • f
    Name one inference rule used to derive FDs?
  • g
    Name one property of ACID?
Section BAttempt any three o f t h e f o l l o w i n g : 7 x 3 = 21
  • a
    Provide examples of mapping cons traints and explain their impa ct on database design?
  • b
    Provide an example and describe how SELECT filters rows from a relation?
  • c
    How does the ORDER BY clause wo rk in SQL? Provide an example?
  • d
    Explain the conditions for a relation to satisfy 5NF and provide examples?
  • e
    Describe the concept of Time Stamping and how it is used to ma nage concurrent transactions?
Section CAttempt any one p a r t o f t h e f o l l o w i n g : 7 x 1 = 7
  • a
    Outline the major modules in a database management system ( DBMS) and their functions?
  • b
    Explain the rules and conventions for creating ER diagrams, including proper use of symbols and notation?
  • a
    Explain the basic concept a nd structure of the Relational Data Model?
  • b
    Compare and contrast Relati onal Algebra with SQL in terms o f query capabilities and syntax?
  • a
    Discuss the importance of c hoosing appropriate data types in database design?
  • b
    Explain the syntax and usage of CREATE, SELECT, INSERT, DEL ETE, and UPDATE statements in SQL?
  • a
    Define multi-valued depende ncies and explain their role in database design?
  • b
    Explain the concept of normalization and its importance in relational database design?
  • a
    Define Conflict Serializability and View Serializability an d explain their differences?
  • b
    Explain how transaction sc heduling affects the execution of transactions in a database system?

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

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

More B.Tech Semester 4 (2023-24) Papers

Other subjects from same semester and session

Analog Circuits2023-24Applied Thermodynamics2023-24Analog Electronics Circuits2023-24Universal Human Values Professional Ethics2023-24Theory Of Automata And Formal Languages2023-24Digital Electronics2023-24Electrical Machines I2023-24Object Oriented Programming With Java2023-24
View all B.Tech Semester 4 2023-24 papers →

Syllabus & More PYQs

Paper solve karne se pehle unit-wise syllabus dekh lo

AKTU 2nd Year PYQs — All Branches