Q.1
14 Marks(a)
Compare DBMS and Distributed DBMS
(b)
Explain location transparency.
(c)
Explain distributed database design process.
Gujarat Technological UniversitySummer 2024 examination
GTU 2170714 Distributed DBMS (DDBMS) Summer 2024 Question Paper & PDF
B.E. · Computer Engineering · Semester 7 · Subject code 2170714
- 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.
Q.2
14 Marks(a)
Compare push only and pull only data delivery mode.
(b)
Define: Data dictionary, global data dictionary
(c)
With the help of example explain horizontal partition.
OR
(c)
With the help of example explain vertical partition.
Q.3
14 Marks(a)
List steps for query processing.
(b)
How can we measure query cost?
(c)
How view management can be done in Distributed DBMS.
OR
(a)
Different query processing of DBMS and DDBMS.
(b)
Explain query optimization.
(c)
List and explain layers of transparency in DDBMS.
Q.4
14 Marks(a)
Explain serializability
(b)
Discuss timestamp based protocols
(c)
List and explain ACID property of transaction.
OR
(a)
List various types of transactions.
(b)
Discuss lock based protocols
(c)
List objectives of distributed concurrency control.
Q.5
14 Marks(a)
Define failure. Give example.
(b)
Explain deadlock.
(c)
How deadlock can be prevented? Explain any one technique.
OR
(a)
List various types of failures.
(b)
Explain two phase commit protocol.
(c)
How deadlock can be detected? Explain wound wait algorithm.
Other Semester 7 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 Distributed DBMS (DDBMS) (Summer 2024, B.E. · Computer Engineering, Sem 7). 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.