Question 1
(a)
Compare DBMS and Distributed DBMS
3 Marks
(b)
Explain location transparency.
4 Marks
(c)
Explain distributed database design process.
7 Marks
Gujarat Technological UniversitySummer 2024 Examination
GTU 2170714 Distributed DBMS (DDBMS) Summer 2024 Paper Solution & PDF
B.E. · Computer Engineering · Semester 7 · Subject Code: 2170714
Total Marks70 MarksExternal theory exam
Passing Marks23 Marks33% minimum cutoff
Exam Duration2.5 Hours2:30 PM – 5:00 PM
Paper Structure5 QuestionsWith internal OR choices
Question 2
(a)
Compare push only and pull only data delivery mode.
3 Marks
(b)
Define: Data dictionary, global data dictionary
4 Marks
(c)
With the help of example explain horizontal partition.
7 Marks
OR OPTION
(c)
With the help of example explain vertical partition.
7 Marks
Question 3
(a)
List steps for query processing.
3 Marks
(b)
How can we measure query cost?
4 Marks
(c)
How view management can be done in Distributed DBMS.
7 Marks
OR OPTION
(a)
Different query processing of DBMS and DDBMS.
3 Marks
(b)
Explain query optimization.
4 Marks
(c)
List and explain layers of transparency in DDBMS.
7 Marks
Question 4
(a)
Explain serializability
3 Marks
(b)
Discuss timestamp based protocols
4 Marks
(c)
List and explain ACID property of transaction.
7 Marks
OR OPTION
(a)
List various types of transactions.
3 Marks
(b)
Discuss lock based protocols
4 Marks
(c)
List objectives of distributed concurrency control.
7 Marks
Question 5
(a)
Define failure. Give example.
3 Marks
(b)
Explain deadlock.
4 Marks
(c)
How deadlock can be prevented? Explain any one technique.
7 Marks
OR OPTION
(a)
List various types of failures.
3 Marks
(b)
Explain two phase commit protocol.
4 Marks
(c)
How deadlock can be detected? Explain wound wait algorithm.
7 Marks
College Exam Groups
Studying for Distributed DBMS?
Circulate this solved paper with KaTeX formulas and 1-click AI step solvers to your batchmates on WhatsApp or Telegram.
About this Examination Paper & Attribution
Official Gujarat Technological University (GTU) examination paper and step-by-step solutions 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.