MCASemester 22024-25Database Management SystemsBMC204
View PDFDownload

Database Management Systems (BMC204) - AKTU Question Paper 2024-25

MCA · Semester 2 · Free PDF Download

This is the official AKTU Database Management Systems Previous Year Question Paper for MCA Semester 2, academic session 2024-25. Published by Dr. A.P.J. Abdul Kalam Technical University (AKTU/UPTU), Lucknow. Free PDF download — no login required.

Course:MCA
Semester:Semester 2
Session:2024-25
University:AKTU / UPTU

Rate this paper

Questions Asked in 2024-25

Database Management Systems (BMC204) — complete question paper · 70 marks · 3 Hours

Section AAttempt all questions in brief. 2 x 07 = 14
  • a
    Discuss the term Data Independence
  • b
    What do you mean by composite attributes?
  • c
    Define Primary Key with example
  • d
    What is the syntax of Insert clause used in SQL?
  • e
    Define the term Functional Dependency
  • f
    What do you mean by Transaction in databases?
  • g
    Define Time Stamping in terms of concurrency control
Section BAttempt any three of the following: 7 x 03 = 21
  • a
    What is three schema architec ture? Discuss in detail
  • b
    Discuss basic operations of Re lational Algebra with examples
  • c
    What do you mean by Normaliza tion? Discuss 1NF, 2NF, and 3NF
  • d
    Discuss various states of a transaction
  • e
    What are various problems enc ountered during concurrency con trol? Discuss each of them
Section CAttempt any one part of the following: 07 x 1 = 07
  • a
    Discuss ER diagram with the help of an example
  • b
    Explain the terms Generalizatio n, Specialization and Aggregation
  • a
    What are the various Integrity Constraints? Discuss each of them
  • b
    Discuss PL/SQL Procedures and Functions with example
  • a
    Define Minimal Cover for a set of functional dependencies. D iscuss with the help of example
  • b
    Discuss lossless join with the help of an example
  • a
    What do you mean by ACID properties of a transaction? Discus s each of them
  • b
    Write short notes on Testing of serializability
  • a
    Discuss Locking Techniques for concurrency control
  • b
    What do you mean by Granularity ? Discuss Multiple Granularity

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.

Database Management Systems — Other Year Papers

AKTU Database Management Systems PYQs from other sessions

Database Management Systems2021-22Database Management Systems2022-23Database Management Systems2023-24Database Management Systems2024-25

More MCA Semester 2 (2024-25) Papers

Other subjects from same semester and session

Operating Systems2024-25Theory Of Automata Formal Languages2024-25Object Oriented Programming2024-25Data Structures Analysis Of Algorithms2024-25Web Technology2024-25Data Structures Analysis Of Algorithms2024-25Operating Systems2024-25Object Oriented Programming2024-25
View all MCA Semester 2 2024-25 papers →