DR. BABASAHEB AMBEDKAR TECHNOLOGICAL UNIVERSITY, LONERE

Regular/Supplementary Examination – 2025

Subject Code & Name: 24UD1246PC304 – Database Management Systems
Course: B.Tech
Branch: Information Technology
Semester: IV
Max Marks: 60
Date: 30/08/2025
Duration: 3 Hours
Instructions to the Students:
  1. Each question carries 12 marks.
  2. Question No. 1 is compulsory and includes objective-type questions.
  3. Attempt any four questions from Q.2 to Q.6.
  4. Use of non-programmable scientific calculators is allowed.
  5. Assume suitable data wherever necessary and mention it clearly.

Q.1 Objective type questions. (Compulsory) – 12 Marks

  1. Which of the following is an advantage of a DBMS over file systems?
    1. Data redundancy increases
    2. Improved data sharing and security
    3. Manual data inconsistency handling
    4. Files are smaller in size
  2. Which of the following provides physical data independence?
    1. External Level
    2. Conceptual Level
    3. Internal Level
    4. None of these
  3. Which is not a component of DBMS?
    1. Query Processor
    2. Data Manager
    3. Operating System
    4. Database
  4. In an E–R model, attributes are represented by:
    1. Rectangles
    2. Ovals
    3. Diamonds
    4. Lines
  5. A primary key must be:
    1. Unique and Not Null
    2. Only Unique
    3. Only Not Null
    4. Can be Null
  6. Referential integrity constraint ensures:
    1. Foreign key matches primary key in referenced table
    2. Every tuple has a unique value
    3. Values are in specified domain
    4. All attributes are atomic
  7. Relational Algebra is:
    1. Procedural query language
    2. Non-procedural query language
    3. Natural language
    4. Low-level machine language
  8. Which SQL command is a DDL command?
    1. INSERT
    2. DELETE
    3. UPDATE
    4. CREATE
  9. A View in SQL is:
    1. A physical copy of data
    2. A virtual table derived from query
    3. A synonym for table
    4. A type of transaction
  10. Which aggregate function is not valid in SQL?
    1. MAX()
    2. SUM()
    3. COUNT()
    4. INCREMENT()
  11. Which normal form removes transitive dependency?
    1. 1NF
    2. 2NF
    3. 3NF
    4. BCNF
  12. Which data structure is used by a DBMS for indexing?
    1. Stack
    2. Queue
    3. B+ Tree
    4. Graph

Q.2 Solve the following. 12 Marks

  1. A) Explain the advantages of DBMS over file systems. (6)
  2. B) Describe the three levels of data abstraction with a neat diagram. (6)

Q.3 Solve the following. 12 Marks

  1. A) Draw and explain the DBMS architecture. (6)
  2. B) Explain different data models in DBMS with examples. (6)

Q.4 Solve Any Two of the following. 12 Marks

  1. A) Explain E–R modeling concepts with example E–R diagram. (6)
  2. B) Define constraints and different types of keys with examples. (6)
  3. C) Explain relational algebra operations with examples. (6)

Q.5 Solve Any Two of the following. 12 Marks

  1. A) Explain SQL DDL commands with examples (CREATE, ALTER, DROP). (6)
  2. B) Write SQL queries using aggregate functions and nested queries. (6)
  3. C) Explain the concept of stored procedures and dynamic SQL. (6)

Q.6 Solve Any Two of the following. 12 Marks

  1. A) Explain functional dependency and its role in normalization. (6)
  2. B) Discuss RAID levels, file organization, B-Trees, and B+ Trees. (6)
  3. C) Explain transaction management: concurrency control & recovery. (6)