Skip to content

Database Management systems (DBMS) important questionsMost repeated in SPPU papers

These 12 questions appeared in more than one SPPU Database Management systems paper we have: 4 papers, from May 2024 to Dec 2025. The most-asked come first. Each one links to the papers it was asked in.

All DBMS papers and notes

Repeated questions

Endsem questions (12)

  1. 3×asked

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

    Dec 2025 ·May 2025 ·May 2024

  2. 3×asked

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

    Dec 2025 ·May 2025 ·May 2024

  3. 2×asked

    Describe the following operations with MongoDB syntax : i) Map- Reduce ii) Aggregation pipeline

    Dec 2025 ·May 2024

  4. 2×asked

    Elaborate the significance of codd’s rule. Explain 12 rules proposed by codd’s.

    Dec 2025 ·May 2025

  5. 2×asked

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

    Dec 2025 ·May 2025

  6. 2×asked

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

    Dec 2025 ·May 2025

  7. 2×asked

    What is functional dependency? Explain its use in database design. Consider the following schema. Student (RollNo, Branch_Code, Marks_Obtained, Exam_Name, Total_Marks) Identify the functional dependencies and check whether the given schema is in 3NF or not. If not justify and convert the schema into 3NF.

    Dec 2025 ·May 2024

  8. 2×asked

    What is the significance of XML databases? Explain with proper example when to use XML database.

    Dec 2025 ·May 2024

  9. 2×asked

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

    Dec 2025 ·May 2025

  10. 2×asked

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

    May 2025 ·May 2024

  11. 2×asked

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

    May 2025 ·May 2024

  12. 2×asked

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

    May 2025 ·May 2024

Questions count as repeated when their wording matches closely across papers. Numericals that depend on a figure are left out, since the figure changes from paper to paper.