JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
MCA V Semester Examinations, December - 2019
--- 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 ---
Max. Marks: 75
--- Content provided by FirstRanker.com ---
SNote: This question paper contains two parts A and B.
--- Content provided by FirstRanker.com ---
Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part Bconsists of 5 Units. Answer any one full question from each unit. Each question carries
10 marks and may have a, b, c as sub questions.
--- Content provided by FirstRanker.com ---
PART - A
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
5 ? 5 Marks = 25
1.a) Distinguish between distributed versus centralized databases.
--- Content provided by FirstRanker.com ---
[5]
--- Content provided by FirstRanker.com ---
b) What is an operator tree of a query? Explain the use of operator graph.
--- Content provided by FirstRanker.com ---
[5]c) What do you mean by distributed transaction? Explain.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5]d) What are the design issues of a reliable distributed database?
--- Content provided by FirstRanker.com ---
[5]
--- Content provided by FirstRanker.com ---
e) What is pointer swizzling? Explain its advantages and disadvantages.[5]
--- Content provided by FirstRanker.com ---
PART - B
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
5 ? 10 Marks = 50
2.a)
--- Content provided by FirstRanker.com ---
What is referential integrity? Give an example.b)
Write the criteria used for checking correctness of fragmentation.
--- Content provided by FirstRanker.com ---
[5+5]
--- Content provided by FirstRanker.com ---
OR3.
Given a global relation:
--- Content provided by FirstRanker.com ---
EMP (EMPNUM, NAME, SAL, TAX, MGRNUM, DEPTNUM).
--- Content provided by FirstRanker.com ---
Write the mixed fragmentation definition and fragmentation tree of relation EMP.[10]
--- Content provided by FirstRanker.com ---
4.a)
How fragmented relation simplification is done? Explain.
--- Content provided by FirstRanker.com ---
b)What is the use of algebra of qualified relations? Discuss.
--- Content provided by FirstRanker.com ---
[5+5]
--- Content provided by FirstRanker.com ---
OR5.
Explain the following for distributed databases.
--- Content provided by FirstRanker.com ---
a) Operations in a parametric query
--- Content provided by FirstRanker.com ---
b) GROUP by operation for evaluating aggregate functions.
--- Content provided by FirstRanker.com ---
[5+5]
--- Content provided by FirstRanker.com ---
6.
Explain in detail various methods used for deadlock detection.
--- Content provided by FirstRanker.com ---
[10]
--- Content provided by FirstRanker.com ---
OR
7.a)
--- Content provided by FirstRanker.com ---
Write about computational structure of distributed transaction.b)
What is serializability? Illustrate this concept with an example.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5+5]8.
--- Content provided by FirstRanker.com ---
Explain about quorum based commitment protocols.--- Content provided by FirstRanker.com ---
[10]
--- Content provided by FirstRanker.com ---
OR9.
Discuss object naming and catalog management with site autonomy.
--- Content provided by FirstRanker.com ---
[10]
--- Content provided by FirstRanker.com ---
10.a) What are the issues related to query processing and optimization in object DBMS?
Discuss.
--- Content provided by FirstRanker.com ---
b) Explain object query processor architecture.--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5+5]OR
11.a) Define type lattice and its management.
--- Content provided by FirstRanker.com ---
b) Explain the management of composition graph.--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5+5]---ooOoo---
--- Content provided by FirstRanker.com ---