Skip to content
InsemApr 20262019 patternSE IT

Database Management System (DBMS) SPPU Insem Question Paper Apr 2026

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
Apr 2026
Max. marks
30
Time
1 Hour
Semester
IV
Paper code
APR-26/SE/Insem-277

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

Instructions to the candidates

  1. Answer Q.1 or Q.2 and Q.3 or Q.4.
  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)

      Explain Advantages of DBMS over file processing systems.

      Also asked:Mar 2025

      [5]
    2. b)

      Explain concept of data abstraction in detail with diagram.

      [5]
    3. c)

      Explain different keys with example.

      [5]

  2. Q2

    1. a)

      Explain overall structure of DBMS with diagram.

      [7]
    2. b)

      Write note on : i) DDL ii) DML

      [8]

  3. Q3

    1. a)

      List and explain Components of ER model.

      [6]
    2. b)

      What is domain explain with example in DBMS.

      [4]
    3. c)

      Write a note on views.

      [5]

  4. Q4

    1. a)

      Explain all Codd’s rules in detail.

      [6]
    2. b)

      Explain with example concept of naming convention.

      [5]
    3. c)

      This part has equations that don’t show as text. Open the PDF to read it.

      [4]