UnFoldPrep
Browse Archive
Gujarat Technological UniversitySummer 2024 Examination

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

B.E. · Computer Engineering · Semester 3 · Subject Code: 3130703
Download Official GTU PDF
Share:
Total Marks70 MarksExternal theory exam
Passing Marks23 Marks33% minimum cutoff
Exam Duration2.5 Hours10:30 AM – 1:00 PM
Paper Structure5 QuestionsWith internal OR choices
Jump toQ1Q2Q3Q4Q5

Question 1

14 MarksMedium
(a)
Define Logical Data Independence and Physical Data Independence.
3 Marks
(b)
Draw and explain 3 layers of abstraction of DBMS
4 Marks
(c)

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.
7 Marks

Question 2

14 MarksMedium
(a)
List various symbol used for ER diagram
3 Marks
(b)
Define referential integrity constraint with example.
4 Marks
(c)

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

7 Marks
OR OPTION
(c)

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

7 Marks

Question 3

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

Question 4

14 MarksMedium
(a)
What is relational model? Explain schema diagram using example.
3 Marks
(b)
Define transaction and its properties?
4 Marks
(c)
Write a note on view serializability
7 Marks
OR OPTION
(a)
With the help of example explain Generalization..
3 Marks
(b)
Define various approach used for Log based recovery
4 Marks
(c)
List and explain various types of Locks used for concurrency control.
7 Marks

Question 5

14 MarksMedium
(a)
How can we print output in PL/SQL block? Give example.
3 Marks
(b)
Explain cursor and its types.
4 Marks
(c)

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.
7 Marks
OR OPTION
(a)
Define encryption and decryption.
3 Marks
(b)
List various types of Trigers.
4 Marks
(c)

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

7 Marks
College Exam Groups

Studying for Database Management Systems?

Circulate this solved paper with KaTeX formulas and 1-click AI step solvers to your batchmates on WhatsApp or Telegram.

Related papers

About this Examination Paper & Attribution

Official Gujarat Technological University (GTU) examination paper and step-by-step solutions 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 PDF