MCA V Semester Examinations, January - 2018
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
--- Content provided by FirstRanker.com ---
Note: This question paper contains two parts A and B.
Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part B
--- Content provided by FirstRanker.com ---
consists of 5 Units. Answer any one full question from each unit. Each question carries 10marks 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 = 251.a)
What is replication transparency? What is its significance?
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5]b)
Demonstrate the use of parametric queries.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5]
--- Content provided by FirstRanker.com ---
c)
What is a nested transaction? Quote examples.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5]
--- Content provided by FirstRanker.com ---
d)Define reliability. How to measure reliability of a system?
--- Content provided by FirstRanker.com ---
[5]
--- Content provided by FirstRanker.com ---
e)Give object query processor architectures.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5]
--- Content provided by FirstRanker.com ---
PART - B
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
5 ? 10 Marks = 50
--- Content provided by FirstRanker.com ---
2.
With necessary reference structure explain various levels of distribution transparency.
Quote an example application.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[10]
--- Content provided by FirstRanker.com ---
OR3.
What is an integrity constraint? What is its importance in distributed databases? Explain
--- Content provided by FirstRanker.com ---
with suitable examples.--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[10]
--- Content provided by FirstRanker.com ---
4.How can qualified relations optimize query processing in distributed databases? Give
illustrative examples.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[10]
--- Content provided by FirstRanker.com ---
OR
5.
--- Content provided by FirstRanker.com ---
Describe a frame work for query optimization and explain general queries optimization.--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[10]
--- Content provided by FirstRanker.com ---
6.a)
Explain the architectural aspects of distributed transactions.
--- Content provided by FirstRanker.com ---
b)Give any one protocol for optimistic methods for concurrency control.
--- Content provided by FirstRanker.com ---
[5+5]
OR
--- Content provided by FirstRanker.com ---
7.What is a deadlock in distributed databases? Suggest various ways of handling them with
illustrations.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[10]
--- Content provided by FirstRanker.com ---
8.Explain two-phase commit protocol and compare it with three-phase commit protocols.[10]
OR
--- Content provided by FirstRanker.com ---
9.
What are the various approaches to detect inconsistencies in distributed databases data?
Explain any one resolution method.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[10]
--- Content provided by FirstRanker.com ---
10.Does common object request broker architecture provide interoperability? Justify your
answer with necessary discussions.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[10]OR
11.
--- Content provided by FirstRanker.com ---
Explain transaction management in multi database system. Discuss challenges faced here
compared to centralized database.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[10]
--- Content provided by FirstRanker.com ---
---oo0oo---