B.TechSemester 62022-23Basics Of Data Base Management SystemKOE-067
View PDFDownload

Basics Of Data Base Management System (KOE-067) - AKTU Question Paper 2022-23

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 2022-23. 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:2022-23
University:AKTU / UPTU

Rate this paper

Questions Asked in 2022-23

Basics Of Data Base Management System (KOE-067) — complete question paper

Section AAttempt all questions in brief. 2 x 10 = 20
  • a
    Define Database, DBMS, and Metadata
  • b
    Discuss the problems with File systems
  • c
    Define Instance and Domain
  • d
    Define Recursive Relationship with example
  • f
    Define the term Data Dictionary
  • g
    List and describe SQL Logical Operators in brief
  • h
    Describe DROP command with options. i. Define Two Phase Commit protocol. j. Define a checkpoint
Section BAttempt any three of the following: 10x3=30
  • a
    Define Data Abstraction and discuss levels of Ab straction
  • b
    Explain about different types of integrity constraints with examples
  • c
    Illustrate Group by and Having clauses with exam ples
  • d
    Define decomposition and how does it address redundancy? Discuss the problems that may be caused by the use of decompositions?
  • e
    Discuss Serializability in detail
Section CAttempt any one part of the following: 10x1=10
  • a
    Describe the Structure of DBMS. Write about view s and updates on views
  • b
    Distinguish strong entity set with weak entity s et. Draw an ER diagram to illustrate weak entity set?
  • a
    Define Join. Explain different types of joins
  • b
    Discuss different types of aggregate operators w ith examples in SQL?
  • a
    Define functional dependencies and relation of p rimary keys with FD’s?
  • b
    Illustrate Multivalued dependencies and Fourth normal form with example
  • a
    Explain ACID properties and Illustrate them thro ugh examples
  • b
    Describe Validation-based locking protocols. Dis cuss in detail Multiple Granularity
  • a
    Explain different types of Recovery Techniques
  • b
    Explain Armstrong’s inference rules? Suppose we are given relation R with attributes A, B, C, D, E, F, and the FDs, A→BC , B →E, CD →EF . Prove that FD: AD →F also holds in R

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

Basics Of Data Base Management System2021-22Basics Of Data Base Management System2023-24Basics Of Data Base Management System2024-25

More B.Tech Semester 6 (2022-23) Papers

Other subjects from same semester and session

Digital Communication2022-23Image Analytics2022-23Power System Ii2022-23Design Of Concrete Structures2022-23Analog Signal Processing2022-23Web Technology2022-23Data Analytics2022-23Microcontrollers Embedded System2022-23
View all B.Tech Semester 6 2022-23 papers →

Syllabus & More PYQs

Paper solve karne se pehle unit-wise syllabus dekh lo

📘 Basics of Data Base Management System — Unit-wise SyllabusBOE067AKTU 3rd Year SyllabusAKTU 3rd Year PYQs — All BranchesCSE 3rd Year SyllabusIT 3rd Year Syllabus