Gujarat Technological UniversitySummer 2024 examination

GTU 3130703 Database Management Systems (DBMS) Summer 2024 Question Paper & PDF

B.E. · Computer Engineering · Semester 3 · Subject code 3130703
Download official PDFView PDF here
Share with your class
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.

10 of 25 questions on this paper were also asked in other years. 2 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.1

14 Marks
(a)
3 marksAsked in 2 of 7 papers
Define Logical Data Independence and Physical Data Independence.

Also asked in Summer 2025 Q1a

(b)
4 marksAsked in 3 of 7 papers
Draw and explain 3 layers of abstraction of DBMS

Also asked in Winter 2025 Q1b, Summer 2025 Q2a

(c)
7 marksSame type asked in 3 of 7 papers

Write relational algebra expression for following (query 1,2 and 3 carry one mark/query 4 & 5 carry two marks) Employee(eid, ename, salary, deptid) Department(deptid, dname)

1)List name of all employee
2)List all the departments with id >5 Marks
3)List sum of the salary all employees.
4)Department wise count the number of employees
5)Find the name of employee earning highest salary.

Also asked in Summer 2026 Q2a, Winter 2023 Q3b, Winter 2023 Q3b OR

Q.2

14 Marks
(a)
3 marks
List various symbol used for ER diagram
(b)
4 marksAsked in 2 of 7 papers
Define referential integrity constraint with example.

Also asked in Winter 2023 Q2b

(c)
7 marksAsked in 4 of 7 papers

List the Armstrong axioms used to compute closure of the set of functional dependency.

Also asked in Summer 2026 Q2b, Summer 2025 Q3c OR, Winter 2024 Q3b OR

(c)
7 marks

What is decomposition? Explain dependency preserving decomposition with the help of example.

Q.3

14 Marks
(a)
3 marks
Give syntax of command used to add a new column in a table.
(b)
4 marks
Define indexing. How will it be useful for searching data?
(c)
7 marks
How can we measure cost of Join query? Explain using example.
(a)
3 marks
Write an SQL command to modify the content of table.
(b)
4 marks
Explain sparse indexing with the help of diagram.
(c)
7 marksAsked in 6 of 7 papers
Draw and explain the query processing steps

Also asked in Summer 2026 Q4c OR, Winter 2025 Q4c, Winter 2024 Q4c OR, Winter 2023 Q4c, Summer 2023 Q3c OR

Q.4

14 Marks
(a)
3 marks
What is relational model? Explain schema diagram using example.
(b)
4 marksAsked in 7 of 7 papers
Define transaction and its properties?

Also asked in Summer 2026 Q3a, Winter 2025 Q4b OR, Summer 2025 Q3a OR, Winter 2024 Q4b OR, Winter 2023 Q4a, Summer 2023 Q4c

(c)
7 marksAsked in 3 of 7 papers
Write a note on view serializability

Also asked in Summer 2026 Q4c, Winter 2023 Q4c OR

(a)
3 marks
With the help of example explain Generalization..
(b)
4 marksAsked in 3 of 7 papers
Define various approach used for Log based recovery

Also asked in Winter 2025 Q5a, Summer 2023 Q4a

(c)
7 marksAsked in 3 of 7 papers
List and explain various types of Locks used for concurrency control.

Also asked in Winter 2025 Q4a, Winter 2023 Q4a OR

Q.5

14 Marks
(a)
3 marks
How can we print output in PL/SQL block? Give example.
(b)
4 marksAsked in 4 of 7 papers
Explain cursor and its types.

Also asked in Summer 2026 Q5a OR, Summer 2025 Q4b OR, Winter 2023 Q5a OR

(c)
7 marksSame type asked in 6 of 7 papers

Write SQL queries for the following (query 1,2 and 3 carry one mark/query 4 & 5 carry two marks) Employee(eid, ename, salary, deptid) Department(deptid, dname)

1List name of all employee
2List all the departments with id > 5
3List sum of the salary all employees.
4Department wise count the number of employees
5Find the name of employee earning highest salary.

Also asked in Summer 2026 Q5c, Summer 2026 Q5c OR, Winter 2025 Q5c OR, Summer 2025 Q5c OR, Winter 2023 Q5c, Winter 2023 Q5c OR, Summer 2023 Q5c

(a)
3 marks
Define encryption and decryption.
(b)
4 marks
List various types of Trigers.
(c)
7 marks

What is role? How can we authorize a user using grant and revoke command? Give example.

More Database Management Systems papers

Questions repeat across sessions. Working through two or three papers shows you which topics GTU asks most.

Summer 202670 marks · 5 questions
Winter 202570 marks · 5 questions
Summer 202570 marks · 5 questions
Winter 202470 marks · 5 questions

Other Semester 3 subjects

BE Computer

130001
Mathematics-III
3130004
Effective Technical Communication
3130006
Probability and Statistics
3130702
Data Structures

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 2024, 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.

Download official PDF All Database Management Systems Papers (7) →Report a typo or correction
ViewDownload PDF