Skip to content
EndsemMay 20242019 patternSE Comp

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

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 2024
Max. marks
70
Time
2½ Hours
Semester
I
Paper code
[6262]-35

Printed for: T.E.(Computer Engineering/AIDS )

Instructions to the candidates

  1. Answer Q.1or 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:Dec 2025

      [9]
    2. b)

      Explain following Codd’s rules with suitable examples: i) Guaranteed Access Rule ii) Comprehensive Data Sub-Language Rule iii) Integrity Independence iv) Systematic Treatment of NULL Values.

      [8]

  2. Q2

    1. a)

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

      Also asked:May 2025

      [8]
    2. b)

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

      [9]

  3. Q3

    1. a)

      What is recoverable schedule? Why is recoverability of schedule desirable?Are there any circumstance under Which it could be desirable to allow non recoverable schedular? Explain your answer.

      [9]
    2. b)

      State and explain the ACID properties. During its execution a transaction passes through several states, until it finally commits or aborts. List all possible sequences of states through which a transaction may pass. Explain the situations when each state transition occours.

      [9]

  4. Q4

    1. a)

      What is R-timestamp (Q) and W-timestamp(Q). Explain the necessary condition used by time stamp ordering protocol to execute for a read/write operation.

      [9]
    2. b)

      What is conflict serializability? Check following schedule is conflict serializable or not? Also, explain the concept of conflict equivalent schedule. T1 T2 T3 T4 R(X) R(Z) W(X) R(Y) W(Y) W(X) W(Y) W(Z) R(X) denotes read operation on data item X by transaction Ti. W(X) denotes read operation on data item X by transaction Ti.

      [9]

  5. Q5

    1. a)

      List the different NOSQL data models. Explain document store NOSQL data model with example.

      [8]
    2. b)

      Draw and explain architecture of Distributed database system. State the reasons for building distributed database systems. 3

      [9]

  6. Q6

    1. a)

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

      Also asked:Dec 2025 ·May 2025

      [9]
    2. b)

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

      Also asked:Dec 2025

  7. Q7

    1. a)

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

      Also asked:Dec 2025

      [9]
    2. b)

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

      Also asked:Dec 2025 ·May 2025

      [9]

  8. Q8

    1. a)

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

      Also asked:May 2025

      [9]
    2. b)

      What is Deductive Database. Explain its features and state its advantanges over traditional database. 

      Also asked:May 2025

      [9]