R17
Code No: 845AD
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
--- Content provided by FirstRanker.com ---
2021 MCA V Semester Examinations, July/August - 2021
DISTRIBUTED DATABASES
--- Content provided by FirstRanker.com ---
Time: 3 Hours--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
Max.Marks:75
Answer any five questions
--- Content provided by FirstRanker.com ---
All questions carry equal marks- - -
--- Content provided by FirstRanker.com ---
1.What is Distributed Database? List and briefly explain advantages of Distributed
database with centralized approach.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[15]2.
--- Content provided by FirstRanker.com ---
Define Transparency. Explain in detail about the layers of transparencies in distributed
database design.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[15]3.a)
--- Content provided by FirstRanker.com ---
Discuss how query optimization is useful in distributed databases.b)
Explain about Semi-joins with example.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[8+7]
--- Content provided by FirstRanker.com ---
4.What is meant by semantic query optimization? How does it differ from other query
optimization techniques?
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[15]
--- Content provided by FirstRanker.com ---
5.
What is Transaction? Explain the properties of Transactions with example.
--- Content provided by FirstRanker.com ---
[15]
--- Content provided by FirstRanker.com ---
6.Explain different optimistic methods for distributed concurrency control.
[15]
--- Content provided by FirstRanker.com ---
7.
Explain the following
--- Content provided by FirstRanker.com ---
a) Checkpointsb) Cold Restart.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[7+8]
--- Content provided by FirstRanker.com ---
8.
--- Content provided by FirstRanker.com ---
Explain about Transaction and Computation Model for Distributed Multi-DBMS indetail with an example.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[15]
--- Content provided by FirstRanker.com ---
---oo0oo---
--- Content provided by FirstRanker.com ---