JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
MCA V Semester Examinations, February - 2022
--- Content provided by FirstRanker.com ---
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.a) Explain the features of distributed databases over centralized databases.b) What is fragmentation? Explain.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[8+7]2.
--- Content provided by FirstRanker.com ---
With a neat diagram explain the reference architecture for distributed databases. [15]
--- Content provided by FirstRanker.com ---
3.Explain the following.
--- Content provided by FirstRanker.com ---
a) Parametric queries.
b) semi join reduction.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[8+7]
--- Content provided by FirstRanker.com ---
4.
--- Content provided by FirstRanker.com ---
Discuss about the framework for query optimization.--- Content provided by FirstRanker.com ---
[15]
--- Content provided by FirstRanker.com ---
5.
Discuss about distributed deadlocks.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[15]6.
--- Content provided by FirstRanker.com ---
What is transaction? With suitable examples explain ACID properties. What are the goals
of transaction management?
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[15]
--- Content provided by FirstRanker.com ---
7.a) Discuss in detail about checkpoints.b) What are the design issues of a reliable distributed database?
--- Content provided by FirstRanker.com ---
[8+7]
--- Content provided by FirstRanker.com ---
8.a) Explain about pointer swizzling.
b) Write about transaction management in object DBMS.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[7+8]--- Content provided by FirstRanker.com ---
---oo0oo---