Skip to content
EndsemMay 20252019 patternSE Comp

Database Management systems (DBMS) SPPU Endsem Question Paper May 2025

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

Open the PDFMost repeated DBMS questions
Subject code
310241
Pattern
2019 pattern
Exam
Endsem
Session
May 2025
Max. marks
70
Time
2½ Hours
Semester
V
Paper code
[6403]-35

Printed for: T.E. (Computer Engineering) (AI.D.S)

Instructions to the candidates

  1. Answers Q.1 or Q.2, Q.3 or Q.4, Q.5 or Q.6, Q.7 or Q.8.
  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)

      What is the impact of insert, update and delete anomaly on overall design of database? How normalization is used to remove these anomalies?

      Also asked:May 2024

      [8]
    2. b)

      Elaborate the signigicance of CODD’s rule. Explain 12 rules proposed by CODD’s.

      Also asked:Dec 2025

      [9]

  2. Q2

    1. a)

      What are the desirable properties of decomposition? Explain it with example.

      [8]
    2. b)

      Explain partial, full and transitive dependency with examples.

      [9]

  3. Q3

    1. a)

      How to ensure the atomicity using Recovery Methods? Explain the log based recovery method in detail.

      Also asked:Dec 2025

      [9]
    2. b)

      When do deadlocks happen, how to prevent them, and how to recover if deadlock takes place? 2

      Also asked:Dec 2025

      [9]

  4. Q4

    1. a)

      What is conflict serializability? How to check schedule is conflict serializable schedule? Explain with one example.

      [9]
    2. b)

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

      [9]

  5. Q5

    1. a)

      Explain the CAP theorem referred during the development of any distributed application.

      [8]
    2. b)

      Explain the NOSQL database types with examples and write down the real time applications.

      Also asked:Dec 2025

      [9]

  6. Q6

    1. a)

      Explain Structured, Semi-structured and Unstructured data types with examples.

      Also asked:Dec 2025 ·May 2024

      [9]
    2. b)

      List the different NOSQL data models. Explain following NOSQL database types with examples. i) Column-oriented ii) Document-oriented

      [8]

  7. Q7

    1. a)

      What is the significance of XML databases? Explain with example the use of XML databases.

      [9]
    2. b)

      What is Deductive Database. Explain its features and state its advantages over traditional database.

      Also asked:May 2024

      [9]

  8. Q8

    1. a)

      Write a short note on complex data types: i) Semi-structured data ii) Features of semi-structured data modeles

      Also asked:May 2024

      [9]
    2. b)

      Explain how encoding and decoding of JSON object is done in JAVA with example. … … …

      Also asked:Dec 2025 ·May 2024

      [9]