Second Year EngineeringAI & Data ScienceSemester 43 credits

Database Management systems (DBMS)SPPU question papers (PYQ), solutions and notes

Core NEP 2024 theory subject for AI & Data Science: Database Management systems

resources for this subject

Subject code PCC-251-AID

Free to browse. Sign in to open files.

Database Management systems (DBMS, subject code PCC-251-AID) is a semester 4 subject in Second Year Engineering, AI & Data Science, at Savitribai Phule Pune University (SPPU).

Here you’ll find 4 previous question papers (2024–2025), 6 unit notes, the syllabus and 1 video lecture.

Every question of 3 papers (May 2024 to Dec 2025) is written out on the paper pages below, so you don’t need to open a PDF.

Insem papers are 30 marks (1 hour) and endsem papers are 70 marks (2½ hours). These are 2019-pattern papers.

Papers for every SE AI & Data Science Sem 4 subject

DBMS previous year question papers

Pick a paper to read all its questions. No sign-in needed.

EndsemDec 2025 May 2024

InsemAug 2025

Most repeated DBMS questions

Asked in more than one SPPU paper, out of 3 we have.

2×asked
Describe the following operations with MongoDB syntax : i) Map- Reduce ii) Aggregation pipeline
Dec 2025 ·May 2024
2×asked
Explain how encoding and decoding of JSON object is done JAVA with example. ♦♦♦
Dec 2025 ·May 2024
2×asked
Explain Structured, Semi-structured and Unstructured data types with examples.
Dec 2025 ·May 2024
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
2×asked
What is the significance of XML databases? Explain with proper example when to use XML database.
Dec 2025 ·May 2024