--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
MCA V Semester Examinations, February - 2022
--- Content provided by FirstRanker.com ---
DISTRIBUTED DATABASES
Time: 3 Hours
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
Max.Marks:75
--- Content provided by FirstRanker.com ---
Answer any five questions
All questions carry equal marks
--- Content provided by FirstRanker.com ---
- - -1.
--- Content provided by FirstRanker.com ---
Explain with examples various types of data fragmentation.--- Content provided by FirstRanker.com ---
[15]
--- Content provided by FirstRanker.com ---
2.a)Describe the reference architecture of distributed database systems.
b)
--- Content provided by FirstRanker.com ---
What are integrity constraints explain in detail.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[8+7]
3.a)
--- Content provided by FirstRanker.com ---
Illustrate with examples query optimization of aggregate functions and parametric
functions.
b)
--- Content provided by FirstRanker.com ---
Discuss the process of query optimization.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[8+7]
--- Content provided by FirstRanker.com ---
4.a)What is query translation? Explain equivalence query transformation.
b)
--- Content provided by FirstRanker.com ---
How a global query is transformed into fragment query?
--- Content provided by FirstRanker.com ---
[8+7]
--- Content provided by FirstRanker.com ---
5.
Define dead lock? Discuss in detail various control organizations for distributed dead lock
--- Content provided by FirstRanker.com ---
detection.--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[15]6.
--- Content provided by FirstRanker.com ---
What is a correct distributed concurrency control mechanism? List some correct distributed
concurrency control mechanism. Prove that time stamp based protocol is correct. [15]
--- Content provided by FirstRanker.com ---
7.a)What is check point? Explain its roles in recovery procedures.
b)
--- Content provided by FirstRanker.com ---
List out optimistic methods for distributed concurrency? Explain them in brief.
[7+8]
--- Content provided by FirstRanker.com ---
8.
Write a short note on:
--- Content provided by FirstRanker.com ---
a) Pointer swizzlingb) Object Migration.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[7+8]---oo0oo---
--- Content provided by FirstRanker.com ---