Explain the components of a DBMS with neat diagram.
Database Management System Question Papers - SPPU University
Access and download Database Management System question papers from Savitribai Phule Pune University (SPPU). Our collection includes INSEM (Internal Semester) and ENDSEM (End Semester) exam papers.
Available Database Management System Papers
We offer 4 question papers for Database Management System, covering various exam patterns and years. All papers are in PDF format for easy viewing and download.
INSEM Papers for Database Management System
Prepare for mid-term evaluations with Database Management System INSEM papers, aligned with the SPPU exam pattern and syllabus.
ENDSEM Papers for Database Management System
Access Database Management System ENDSEM papers covering the entire syllabus, essential for final exam preparation.
Online PDF Viewer Features
Our question-paper viewer enables you to:
- View papers in single or split-screen mode.
- Compare multiple papers simultaneously.
- Use fullscreen mode for better readability.
- Filter by exam type (INSEM/ENDSEM).
- Download papers for offline study.
About SPPU Question Papers Hub
SPPU Question Papers Hub is focused entirely on SPPU previous year papers, with cleaner discovery by branch, semester, and subject.
Study Materials for Database Management System
Database Management System is a key subject in the SPPU curriculum. Our question paper collection helps students understand exam patterns, practice effectively, and improve academic performance.
Relevant Keywords & Topics
Explore Database Management System resources including SPPU question papers from Savitribai Phule Pune University. Find INSEM and ENDSEM papers for effective examination preparation. Our platform offers academic resources, a PDF viewer for online study, university question papers, and materials for semester examinations.
Database Management System
Single
Single
Split (2)
Split (3)
Grid (4)
Download Database Management System Papers
INSEM Papers
Download all INSEM question papers as ZIP
ENDSEM Papers
Download all ENDSEM question papers as ZIP
All Papers
Download all question papers (INSEM + ENDSEM) as ZIP
Database Management System Questions
Pre-rendered question cards from available structured metadata.
2025 May Jun ENDSEM
2026 Mar INSEM
2025 Mar INSEM
2025 May Jun ENDSEM
2025 Nov Dec ENDSEM
INSEM
2026 Mar INSEM
12 Questions
Q1
15 Marks
Q1
·
b
·
4 Marks
List four significant differences between a file-processing system and DBMS.
Q1
·
c
·
5 Marks
List and Explain different type of attribute in ER data model with example.
Q2
15 Marks
Q2
·
a
·
5 Marks
What is a data model? Discuss any two types of data model.
Q2
·
b
·
5 Marks
Describe the three levels of data abstraction with a neat diagram.
Q2
·
c
·
5 Marks
Discuss the concept of data independence and explain its importance in a database environment.
Q3
15 Marks
Q3
·
a
·
5 Marks
Discuss the differences between the candidate keys and the primary key of a relation. Explain what is meant by a foreign key. How do foreign keys of relations relate to candidate keys?
Q3
·
b
·
5 Marks
What is a view? Discuss the difference between a view and a base relation. Explain with example.
Q3
·
c
·
5 Marks
List and explain any 6 Codd’s rule.
Q4
15 Marks
Q4
·
a
·
5 Marks
Construct an E-R diagram for a car insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. Each insurance policy covers one or more cars, and has one or more premium payments associated with it. Each payment is for a particular period of time and has an associated due date and the date when the payment was received.
Q4
·
b
·
5 Marks
Explain properties (any three) of Relations. Describe the terms relation and relation schema.
Q4
·
c
·
5 Marks
Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules.
| Subject Name | Database Management System |
|---|---|
| Semester | IV |
| Pattern Year | 2019 |
| Subject Code | 218554 |
| Max Marks | 30 |
| Total Questions | 4 |
| Duration | 1 Hour |
| Paper Number | APR-26/SE/Insem-283 |
| Academic Year | S.E. |
| Branch Name | AIML |
| Exam Type | INSEM |
| Exam Session | 2026 Mar INSEM |
| Watermark | ['CEGP013091', '49.248.216.237 12/03/2026 13:51:39 static-237'] |
INSEM
2025 Mar INSEM
10 Questions
Q1
15 Marks
Q1
·
a
·
7 Marks
Explain multi-user DBMS architecture in detail.
Q1
·
b
·
8 Marks
Write a short note on System Catalog.
Q2
15 Marks
Q2
·
a
·
7 Marks
Explain different Data Models in detail with example.
Q2
·
b
·
8 Marks
Explain Data Independence in detail with example.
Q3
15 Marks
Q3
·
a
·
5 Marks
Explain Converting ER diagrams into tables with example.
Q3
·
b
·
5 Marks
Write a short note on Enterprise Constraint.
Q3
·
c
·
5 Marks
Explain EER diagram features in detail with example.
Q4
15 Marks
Q4
·
a
·
5 Marks
Explain Codd’s rule in detail.
Q4
·
b
·
5 Marks
Explain the difference between ER diagram and Scheme diagram.
Q4
·
c
·
5 Marks
Explain relational model with the terminologies and examples.
| Subject Name | Database Management System |
|---|---|
| Semester | IV |
| Pattern Year | 2019 |
| Subject Code | 218554 |
| Max Marks | 30 |
| Total Questions | 4 |
| Duration | 1 Hour |
| Paper Number | [6409]-243 |
| Academic Year | S.E. |
| Branch Name | Artificial Intelligence & Machine Learning |
| Exam Type | INSEM |
| Exam Session | 2025 Mar INSEM |
| Watermark | ['CEGP013091', '49.248.216.237 13/03/2025 13:59:46 static-237'] |
ENDSEM
2025 May Jun ENDSEM
24 Questions
Q1
18 Marks
Q1
·
a
·
8 Marks
Consider the following schema for a company database Employee (Name, SSN, Address, Sex, Salary, Dno) Department (Dname, Dnumber, MGRSSN, MGRSTART Date) Dept-Locations (Dnumber, Dlocations) Project(Pname, Pnumber, Plocations, Dnum) Works-on (ESSN, PNo, Hours) Dependent (ESSN, Dependent-name, Sex, Bdate, Relationship) Give the queries in SQL: i) Retrieve the names and address of employees who work for “Research” Department. ii) List all the project names on which employee “Smith” is working. iii) Retrieve all employees in Dept. 5 whose salary is between 30,000 and 40,000. iv) Retrieve the name of each employee who works on all the projects controlled by department number 5.
Q1
·
b
·
5 Marks
Compare stored procedure and functions from PL-SQL.
Q1
·
c
·
5 Marks
What is the significance of views in SQL? Give SQL statement to update data.
Q2
18 Marks
Q2
·
a
·
8 Marks
Use the schema and answer the queries in SQL. SAILORS (Sid, Sname, rating, age) BOATS (bid, bname, color) RESERVES (sid, bid, day) i) Find names of sailors who reserved green boatem CS/IS 06CS54-10 ii) Find the colors of boats reserved by “Ramesh” iii) Find names of sailors who have reserved a red or a green boat iv) Find the names of the sailors who have reserved a red boat
Q2
·
b
·
5 Marks
What is trigger? How it works? Explain with the help of example.
Q2
·
c
·
5 Marks
Explain with an example aggregate functions and grouping used with SQL.
Q3
17 Marks
Q3
·
a
·
8 Marks
Define BCNF. How does it differ from 3NF? What is it considered a stronger form of 3NF? Explain with appropriate example.
Q3
·
b
·
5 Marks
What do you mean by equivalent minimal set of functional dependencies? Explain with exmple.
Q3
·
c
·
4 Marks
What do you mean by i) Insertion Anomaly ii) Delection Anomaly
Q4
17 Marks
Q4
·
a
·
8 Marks
Which are various measures of query cost? Explain with example.
Q4
·
b
·
5 Marks
What is the dependency preservation property for decomposition? Why is it important?
Q4
·
c
·
4 Marks
Explain each of the following with example i) 1NF ii) 2NF
Q5
18 Marks
Q5
·
a
·
6 Marks
What is schedule? What are the various ways for serializability checks?
Q5
·
b
·
6 Marks
What is deadlock? Explain how deadlock detection and prevention is done.
Q5
·
c
·
6 Marks
When schedule can be called as recoverable schedule? Explain with example.
Q6
18 Marks
Q6
·
a
·
6 Marks
What is concept of Transaction? Which properties transaction must ensure? Explain each property.
Q6
·
b
·
6 Marks
Compare two protocols used for concurrency control.
Q6
·
c
·
6 Marks
Write short note on: Shadow paging.
Q7
17 Marks
Q7
·
a
·
6 Marks
Explain architecture of parallel database.
Q7
·
b
·
6 Marks
How atomicity is ensured in distributed databases? Explain protocol used for it.
Q7
·
c
·
5 Marks
Write short note on NoSQL databases.
Q8
17 Marks
Q8
·
a
·
6 Marks
What are various data distribution strategies in distributed databases?
Q8
·
b
·
6 Marks
Explain 2 tier and 3 tier architecture of databases with suitable diagram.
Q8
·
c
·
5 Marks
Write short note on XML databases.
| Subject Name | Database Management System |
|---|---|
| Semester | IV |
| Pattern Year | 2019 |
| Subject Code | 218554 |
| Max Marks | 70 |
| Total Questions | 8 |
| Duration | 2½ Hours |
| Paper Number | [6402]-71 |
| Academic Year | S.E. |
| Branch Name | Artificial Intelligence and Machine Learning |
| Exam Type | ENDSEM |
| Exam Session | 2025 May Jun ENDSEM |
| Watermark | ['CEGP013091', '49.248.216.237 31/05/2025 09:43:41 static-237'] |
ENDSEM
2025 Nov Dec ENDSEM
24 Questions
Q1
18 Marks
Q1
·
a
·
8 Marks
Describe the circumstances in which you would choose to use embedded SQL rather than using SQL alone or using only a general purpose programming language. Compare dynamic and embedded SQL with suitable example.
Q1
·
b
·
6 Marks
Consider following database: Student(rollno,name,address) Subject(subjectcode,subjectname) Marks(rollno,subjectcode,marks) Write following queries in SQL 1) Find average marks of each student along with name of student. 2) Find how many student have failed in subject DBMS.
Q1
·
c
·
4 Marks
Differentiate between : WHERE and HAVING clauses in SQL.
Q2
18 Marks
Q2
·
a
·
6 Marks
What is the need of embedded SQL? Explain dynamic SQL with example.
Q2
·
b
·
6 Marks
Explain various set operation in SQL with example..
Q2
·
c
·
6 Marks
What is view? Given the following schema Employee(eno,address,dno,salary) Department(dno,dname,location,manager) Using SQL generate a view to display information department wise as dno, total number of employee, total salary, average salary.
Q3
17 Marks
Q3
·
a
·
7 Marks
Define BCNF? How does it differ from 3NF?why is it consider a stronger form of 3NF?
Q3
·
b
·
6 Marks
Given a relation schema R = (A,B,C,D,E) and function dependency as AC, CD, CEA, BC, DEC. Relation R is decomposed into r1 = AD, r2 = AB, r3 = BE, r4 = CDE, r5 = AE. Decide this decomposition is lossy or lossless ? Justify
Q3
·
c
·
4 Marks
Write a note on Materialization.
Q4
17 Marks
Q4
·
a
·
6 Marks
Compute the closure of following set F of functional dependencies for relation schema R(A,B,C,D,E) ABC, CDE, BD,EA Also find candidate key.
Q4
·
b
·
6 Marks
Show that with suitable example: if a relation schema is in BCNF, then it is also in 3NF
Q4
·
c
·
5 Marks
Explain update anomalies with example.
Q5
18 Marks
Q5
·
a
·
6 Marks
Give test for conflict serializability. Check whether following schedule is conflict serializable. T1 T2 Read(A) Write(A) Read(A) Write(A) Read(B) Write(B) Read(B) Write(B)
Q5
·
b
·
6 Marks
What is meant by transaction? Explain transaction model with state diagram.
Q5
·
c
·
6 Marks
Explain time-stamp based concurrency control.
Q6
18 Marks
Q6
·
a
·
6 Marks
Since every conflict serializable schedule is view serializable, why do we emphasize conflict serializability rather than view serializability.
Q6
·
b
·
6 Marks
When do deadlock happen, how to recover if deadlock takes place?
Q6
·
c
·
6 Marks
Explain deferred database modification and immediate database modification and their differences in the context of recovery.
Q7
17 Marks
Q7
·
a
·
6 Marks
State which database system architecture you will prefer for following application i) Banking system ii) Airline management iii) College admission system
Q7
·
b
·
6 Marks
Explain speed- up and scale-up .issue with respect to parallelism.
Q7
·
c
·
5 Marks
What are the requirement of mobile databases? List existing mobile databases.
Q8
17 Marks
Q8
·
a
·
6 Marks
What is fragment of a relation? what are the main type of fragmentation? Why is fragmentation a useful context in distributed database design.
Q8
·
b
·
6 Marks
Draw and explain architecture of parallel Databases
Q8
·
c
·
5 Marks
Write a note on XML databases.
| Subject Name | Database Management System |
|---|---|
| Semester | IV |
| Pattern Year | 2019 |
| Subject Code | 218554 |
| Max Marks | 70 |
| Total Questions | 8 |
| Duration | 2½ Hours |
| Paper Number | [6582]-66 |
| Academic Year | S.E. |
| Branch Name | Artificial Intelligence & Machine Learning |
| Exam Type | ENDSEM |
| Exam Session | 2025 Nov Dec ENDSEM |
| Watermark | ['CEGP013091', '49.248.216.237 04/12/2025 09:45:46 static-237'] |
Loading PDFs...
INSEM
INSEM
ENDSEM
Select Paper