Skip to content
InsemMar 20252019 patternSE IT

Database Management System (DBMS) SPPU Insem Question Paper Mar 2025

All 4 questions from this SPPU insem paper, as printed. Read them here or open the PDF.

Open the PDF
Subject code
214452
Pattern
2019 pattern
Exam
Insem
Session
Mar 2025
Max. marks
30
Time
1 Hour
Semester
IV
Paper code
[6409]-237

Printed for: S.E. (Information Technology) (Insem)

Instructions to the candidates

  1. Answer Q1 or Q2, Q3 or Q4.
  2. Neat diagrams must be drawn wherever necessary.
  3. Figures to the right indicate full marks.
  4. Assume suitable data, if necessary.

Questions

  1. Q1

    1. a)

      Define Multi-user DBMS architecture.

      [5]
    2. b)

      Explain advantages of DBMS over file processing systems.

      Also asked:Apr 2026

      [5]
    3. c)

      Explain role of Database Administrator in detail.

      [5]

  2. Q2

    1. a)

      Explain Data abstraction in detail.

      [7]
    2. b)

      Write note on: i) System catalogs ii) Data independence

      [8]

  3. Q3

    1. a)

      Write a note on converting ER diagrams into tables.

      [5]
    2. b)

      Explain use of ER diagram in detail.

      [5]
    3. c)

      Explain use of EER diagram in detail.

      [5]

  4. Q4

    1. a)

      Explain with example views.

      [7]
    2. b)

      Write a short note on Referential integrities. 

      [8]