MCA V Semester Examinations, April/May - 2019
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
Note: 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 B
consists 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
--- Content provided by FirstRanker.com ---
1.a) Discuss the relative advantages of centralized and distributed databases.
[5]
--- Content provided by FirstRanker.com ---
b) Discuss about translation of global queries into fragmented queries.[5]
--- Content provided by FirstRanker.com ---
c) Explain Deadlocks in distributed database.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5]
d) Explain about 3-phase commitment protocol.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5]
--- Content provided by FirstRanker.com ---
e) Explain about multi database concurrency control.--- 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 ---
--- Content provided by FirstRanker.com ---
5 ? 10 Marks = 502.a)
Explain how to differ the following : fragmentation transparency, replication
--- Content provided by FirstRanker.com ---
transparency and location transparency.b)
What is meant by data fragmentation in distributed database?
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5+5]OR
3.a)
--- Content provided by FirstRanker.com ---
Explain about integrity constraints in distributed database.
b)
--- Content provided by FirstRanker.com ---
Explain reference architecture for distributed databases.--- Content provided by FirstRanker.com ---
[5+5]
--- Content provided by FirstRanker.com ---
4.a)
Discuss how query optimization is done using AHY algorithm.
--- Content provided by FirstRanker.com ---
b)Explain the Framework for Query Optimization.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5+5]
OR
--- Content provided by FirstRanker.com ---
5.a)
Explain about Parametric Queries in distributed database.
--- Content provided by FirstRanker.com ---
b)Explain about the Evaluation of Aggregate Function.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5+5]6.a)
--- Content provided by FirstRanker.com ---
Explain Deadlock prevention in distributed databases.b)
Explain the deadlock detection in distributed database.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5+5]
OR
--- Content provided by FirstRanker.com ---
7.a)
Explain about the serilizability in distributed database.
--- Content provided by FirstRanker.com ---
b)Explain about conservative time stamp method.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5+5]
--- Content provided by FirstRanker.com ---
8.a)Explain about 2-phase commitment protocol.
b)
--- Content provided by FirstRanker.com ---
Discus about quorum based 3-phase commitment protocol.
--- Content provided by FirstRanker.com ---
[5+5]
OR
--- Content provided by FirstRanker.com ---
9.a)
Explain check points and cold restart in distributed database.
--- Content provided by FirstRanker.com ---
b)Discuss about distributed database administration.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5+5]10.a) Explain about Distributed Component Object Model.
b) Explain the transaction management in Object DBMS.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5+5]
OR
--- Content provided by FirstRanker.com ---
11.a) Explain the Delivery Schedule Algorithm in Push-based Technologies.
b) Discuss between scheme Translation and scheme Integration.
--- Content provided by FirstRanker.com ---
[5+5]
--- Content provided by FirstRanker.com ---
---ooOoo---