MCA V Semester Examinations, August - 2017
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: 60
--- Content provided by FirstRanker.com ---
Note: This question paper contains two parts A and B.Part A is compulsory which carries 20 marks. Answer all questions in Part A. Part B
consists of 5 Units. Answer any one full question from each unit. Each question carries
8 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 ? 4 Marks = 20
--- Content provided by FirstRanker.com ---
1.a) List and explain the necessary components to build a distributed database.
[4]
--- Content provided by FirstRanker.com ---
b) Compare parametric queries with nested queries.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[4]
c) List out the properties of transactions.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[4]d) Describe reliability protocols in distributed systems.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[4]e) List out the activities of Database administrator.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[4]
--- Content provided by FirstRanker.com ---
PART - B
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
5 ? 8 Marks = 40
--- Content provided by FirstRanker.com ---
2.
What are integrity constraints? Discuss how referential integrity is maintained in a
--- Content provided by FirstRanker.com ---
distributed system.--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[8]
--- Content provided by FirstRanker.com ---
OR3.
What are the distribution database design issues? Explain with examples.
--- Content provided by FirstRanker.com ---
[8]
4.
--- Content provided by FirstRanker.com ---
Discuss with a relevant example, how distributed query processing is done using semi
join.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[8]
OR
--- Content provided by FirstRanker.com ---
5.
What is query processing? Explain various steps in distributed query processing along
with transforming global queries to fragmented queries.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[8]
--- Content provided by FirstRanker.com ---
6.Discuss the differences in concurrency control and recovery in centralized and distributed
systems.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[8]
--- Content provided by FirstRanker.com ---
OR7.
Compare Distributed Deadlock prevention to Distributed Deadlock Avoidance. Explain
--- Content provided by FirstRanker.com ---
one scheme of Distributed deadlock Detection and Recovery.--- Content provided by FirstRanker.com ---
[8]
8.
--- Content provided by FirstRanker.com ---
How non blocking commitment protocols ensure reliability? Explain with an example.[8]
OR
--- Content provided by FirstRanker.com ---
9.Explain various techniques used for protecting the database against unauthorized access to
a distributed database.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[8]
--- Content provided by FirstRanker.com ---
10.
--- Content provided by FirstRanker.com ---
Discuss the necessary characteristics a system must satisfy to be considered as an ObjectDBMS.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[8]
OR
--- Content provided by FirstRanker.com ---
11.Briefly explain various components of object query processor architecture.
[8]
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
---oo0oo---