Q.1
14 Marks(b)
What are the responsibilities of a DBA?
(c)
Explain database system 3 tier architecture with clear diagram in detail.
Also asked in Summer 2026 Q1c
Gujarat Technological UniversitySummer 2023 examination
GTU 3130703 Database Management Systems (DBMS) Summer 2023 Question Paper & PDF
B.E. · Computer Engineering · Semester 3 · Subject code 3130703
- Total
- 70 marks
- To pass
- 23 marks (33%)
- Duration
- 2.5 Hours 2:30 PM – 5: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.
14 of 25 questions on this paper were also asked in other years. 1 more is a type 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(c)
Explain Entity Relationship model with example.
OR
Q.3
14 Marks(b)
Explain 3NF with example
(c)
What is functional dependency? Explain its types in detail.
OR
(b)
Explain BCNF with example.
(c)
Enlist and explain the basic steps in Query Processing.
Also asked in Summer 2026 Q4c OR, Winter 2025 Q4c, Winter 2024 Q4c OR, Summer 2024 Q3c OR, Winter 2023 Q4c
Q.4
14 Marks(a)
Explain log based recovery and mention all its types.
Also asked in Winter 2025 Q5a, Summer 2024 Q4b OR
(c)
What is a transaction? Explain the ACID properties.
Also asked in Summer 2026 Q3a, Winter 2025 Q4b OR, Summer 2025 Q3a OR, Winter 2024 Q4b OR, Summer 2024 Q4b, Winter 2023 Q4a
OR
(a)
Write short note on data encryption.
Q.5
14 Marks(b)
Explain Transaction Control Commands
(c)
Consider the following employee database, primary keys are underlined : employee (employee-name, street, city) works (employee-name, company-name, salary) company (company-name, city) manages (employee-name, manager_name) Give an expression in SQL for each of the following queries: 1. Find the names of all employees who work for First Bank Corporation.
2Give all employees of First Bank Corporation a 10 percent raise.
3Find the names and cities of residence of all employees who work for First Bank Corporation.
4Find the names, street addresses, and cities of residence of all employees who work for First Bank Corporation and earn more than $10,000.
5Find all employees in the database who live in the same cities as the companies for which they work.
6Find all employees in the database who do not work for First Bank Corporation.
Also asked in Summer 2026 Q5c, Summer 2026 Q5c OR, Winter 2025 Q5c OR, Summer 2025 Q5c OR, Summer 2024 Q5c, Winter 2023 Q5c, Winter 2023 Q5c OR
OR
(a)
Explain DDL,DML,DCL with example
(b)
Discuss aggregate functions with example(s).
(c)
Explain stored procedures and stored functions.
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) (Summer 2023, 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.