Skip to content
EndsemNov 20252019 patternSE IT

Database Management System (DBMS) SPPU Endsem Question Paper Nov 2025

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

Open the PDF
Subject code
214452
Pattern
2019 pattern
Exam
Endsem
Session
Nov 2025
Max. marks
70
Time
2½ Hours
Semester
IV
Paper code
[6582]-56

Printed for: S.E. (Information Technology)

Instructions to the candidates

  1. Answer Q.1, or Q.2, .Q.3 or Q.4, Q.5 or Q.6, Q.7 or Q.8.
  2. Figures to the right indicate full marks.
  3. Neat diagrams must be drawn whenever necessary.
  4. Make suitable assumption whenever necessary.

Questions

  1. Q1

    1. a)

      Explain SQL data types in detail with example.

      [6]
    2. b)

      Explain with suitable example the concept of view and indexes.

      [6]
    3. c)

      Write a short note on i) Triggers ii) Stored Procedure.

      [6]

  2. Q2

    1. a)

      Explain Set Comparison in detail with example.

      [6]
    2. b)

      What is ODBC? Explain with suitable example.

      [6]
    3. c)

      Compare Embedded SQL and Dynamic SQL in detail.

      [6]

  3. Q3

    1. a)

      Explain how to measure query cost in detail.

      Also asked:May 2025

      [6]
    2. b)

      What is the purpose of Normalization?

      [5]
    3. c)

      Explain the difference between 3NF and BCNF.

      [6]

  4. Q4

    1. a)

      Explain different types of Functional Dependency in detail.

      [6]
    2. b)

      Explain transformation of relational expression in detail.

      [5]
    3. c)

      Explain selection and Join operation in detail with example. 2

      [6]

  5. Q5

    1. a)

      Explain database architecture in detail with diagram.

      [6]
    2. b)

      Explain in detail non recoverable and recoverable schedule.

      [6]
    3. c)

      Explain concept of checkpoints with its purpose.

      [6]

  6. Q6

    1. a)

      Explain Deferred and immediate crash recovery method in detail.

      [6]
    2. b)

      Explain Shadow paging method in detail.

      [6]
    3. c)

      Explain in detail Multi-version Concurrency Control.

      [6]

  7. Q7

    1. a)

      Explain 2 Tier and 3 Tier Architecture in detail with example.

      [6]
    2. b)

      Write short note on: 1. Mobile database 2. Internet databases.

      [6]
    3. c)

      Explain distributed database architecture in detail.

      [5]

  8. Q8

    1. a)

      Explain architecture of parallel database in detail.

      Also asked:May 2025

      [6]
    2. b)

      Write short note on: 1. SQLite database 2. XML databases.

      [6]
    3. c)

      Write short notes on NOSQL database. ♦♦♦

      [5]