Skip to content
EndsemDec 20252019 patternSE AI&DS

Database Management systems (DBMS) SPPU Endsem Question Paper Dec 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
Dec 2025
Max. marks
70
Time
2½ Hours
Semester
V
Paper code
[6583]-42

Printed for: T.E. (Computer Eng ./ AI & DS /Computer Science )

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. 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 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.

      Also asked:May 2024

      [8]
    2. b)

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

      [9]

  2. Q2

    1. a)

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

      [8]
    2. b)

      Explain why database normalization is required for good relational database design. Explain with example requirements of different normal forms like 1NF, 2NF and 3NF. 2

      [9]

  3. Q3

    1. a)

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

      [9]
    2. b)

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

      [9]

  4. Q4

    1. a)

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

      [9]
    2. b)

      Explain two phase locking protocol. Consider the following two transactions : T31: read(A); read(B); if A = 0 then B:=B+1; Write (B) T32: read(B); read(A); if B=0 then A: =A+1; write (A). Add lock and unlock instructions to transactions T31 and T32, so that they observe the two phase locking protocol. Can the execution of these transactions result in a deadlock? 3

      [9]

  5. Q5

    1. a)

      State and explain the concept of CAP theorem and BASE properties with example.

      [9]
    2. b)

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

      [8]

  6. Q6

    1. a)

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

      Also asked:May 2024

      [9]
    2. b)

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

      Also asked:May 2024

      [8]

  7. Q7

    1. a)

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

      Also asked:May 2024

      [9]
    2. b)

      What is object relational database system. Explain Table inheritance with example.

      [9]

  8. Q8

    1. a)

      Write short note on Geographic data and Geometric data.

      [9]
    2. b)

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

      Also asked:May 2024

      [9]