Q.1
14 Marks(a)
Define following terms.
1Schema
2Instance
3Physical Data Independence
(c)
What is integrity constraint? Explain primary key, reference key and check constraint with SQL syntax.
Gujarat Technological UniversityWinter 2025 examination
GTU 3130703 Database Management Systems (DBMS) Winter 2025 Question Paper & PDF
B.E. · Computer Engineering · Semester 3 · Subject code 3130703
- Total
- 70 marks
- To pass
- 23 marks (33%)
- Duration
- 2.5 Hours 10:30 AM – 1:00 PM
- Questions
- 5 with internal choice
No solutions on this paper yetNeed them for your exam? Ask once. Papers that students ask for are solved first, and we aim to add them within 24 hours.
Noted. This paper is in our queue now. Check back tomorrow.
We could not record that here. Email the paper name to hirenjsca@gmail.com and we will add it.
16 of 25 questions on this paper were also asked in other years. 3 more are types of question GTU sets again with new data. Each is marked below with the years it appeared.See all 41 repeated 3130703 questions, most asked first
Q.2
14 Marks(a)
What is Data Definition Language? List DDL statements and explain anyone with an example.
(b)
Describe
1)Union and
2)Cartesian Product operations in relational
algebra.
(c)
Explain the advantages of Database Management Systems over file processing system.
Also asked in Summer 2025 Q1c, Winter 2024 Q1c, Winter 2023 Q1b
OR
(c)
List the type of Database Users. Explain their characteristics in brief. How they interact with DBMS?
Q.3
14 Marks(b)
Briefly explain Generalization and Specialization in E-R diagram.
Also asked in Winter 2024 Q2a, Winter 2023 Q2c
(c)
What is Normalization? Explain 1NF, 2NF and 3NF with suitable example.
Also asked in Summer 2025 Q3c
OR
(b)
Differentiate Sparse and Dense index in DBMS with example.
Also asked in Summer 2026 Q4a, Winter 2023 Q5b
(c)
Draw E-R diagram for a University Management System with the necessary assumption.
Also asked in Summer 2026 Q2c, Summer 2026 Q2c OR, Winter 2024 Q2c
Q.4
14 Marks(a)
List and explain different types of locks in transactions.
Also asked in Summer 2024 Q4c OR, Winter 2023 Q4a OR
(c)
Discuss various steps of query processing with diagram.
Also asked in Summer 2026 Q4c OR, Winter 2024 Q4c OR, Summer 2024 Q3c OR, Winter 2023 Q4c, Summer 2023 Q3c OR
OR
(b)
List and describe ACID property of transactions.
Also asked in Summer 2026 Q3a, Summer 2025 Q3a OR, Winter 2024 Q4b OR, Summer 2024 Q4b, Winter 2023 Q4a, Summer 2023 Q4c
Q.5
14 Marks(a)
What is log-based recovery? List and explain various fields use in log records for log-based recovery.
Also asked in Summer 2024 Q4b OR, Summer 2023 Q4a
(b)
Write a PL/SQL function which takes 3 integer numbers as parameters and return an average of same.
Also asked in Winter 2024 Q5c
(c)
What is a deadlock? How to detect deadlock? Explain with example.
Also asked in Summer 2023 Q4b OR
OR
(a)
Define following terms.
1Cascading Rollback
2Candidate Key
3View
(c)
Write SQL queries for the following:
1Create table Employee, Department and Location with following schema and appropriate data types and constraints.
aEmployee (employee_id, name, email, hire_date, salary, department_id, location_id)
bDepartment (department_id, department_name)
cLocation (location_id, street_address, postal_code, country)
2Add new column ‘city’ in the location table.
3Find all the details of employees whose name starts with or ends with ‘s’.
4Update the postal_code to '220212' where the country is 'India' and location_id is between 2 to 7.
5Delete all the records of Location table.
Also asked in Summer 2026 Q5c, Summer 2026 Q5c OR, Summer 2025 Q5c OR, Summer 2024 Q5c, Winter 2023 Q5c, Winter 2023 Q5c OR, Summer 2023 Q5c
More Database Management Systems papers
Questions repeat across sessions. Working through two or three papers shows you which topics GTU asks most.
Other Semester 3 subjects
BE Computer
Preparing with friends?
Send this paper to your class group. Every question has its own link.
About this paper
Official Gujarat Technological University (GTU) examination paper for Database Management Systems (DBMS) (Winter 2025, B.E. · Computer Engineering, Sem 3). Features complete 70-mark regular & remedial examination pattern, official marking distribution across all 5 questions, and direct 1-click official PDF download.
Transcribed for student exam preparation from Gujarat Technological University official examination archives. Questions, syllabus guidelines, and curriculum marking schemes remain the intellectual property of Gujarat Technological University.