MCA V Semester Examinations, June/July - 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 are the advantages of a distributed database management system over a
centralized DBMS?
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[5]b) Give the comparison of global queries and fragmented queries.
--- Content provided by FirstRanker.com ---
[5]
--- Content provided by FirstRanker.com ---
c) Discuss the ways in which the concurrency control approaches can be classified. [5]d) Define reliability. What are the types of failures in distributed DBMS?
--- Content provided by FirstRanker.com ---
[5]e) Differentiate between DDBMS and MDBMS.
--- 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.
Why is data replication useful in Distributed Database and what typical units of data are
replicated?
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[10]
OR
--- Content provided by FirstRanker.com ---
3.
Distributed databases can be fragmented in many ways. Define the term fragmentation and
explain using real world examples any three types of fragmentation that can be carried out.
--- Content provided by FirstRanker.com ---
--- 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 ---
4.What is query optimization? Give the framework for query optimization in distributed
environment.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[10]
OR
--- Content provided by FirstRanker.com ---
5.List steps of query decomposition and explain any one from that.
--- Content provided by FirstRanker.com ---
[10]
6.
--- Content provided by FirstRanker.com ---
Consider a failure that occurs during 2PC for a transaction. For each possible failure,
explain how 2PC ensures transaction atomicity despite the failure?
--- Content provided by FirstRanker.com ---
[10]
OR
--- Content provided by FirstRanker.com ---
7.Explain briefly about timestamp-based concurrency algorithms.
--- Content provided by FirstRanker.com ---
[10]
--- Content provided by FirstRanker.com ---
8.
Define a catalog. How is it maintained in distributed databases?
--- Content provided by FirstRanker.com ---
[10]
--- Content provided by FirstRanker.com ---
OR
9.
--- Content provided by FirstRanker.com ---
Describe the role of check points and cold restart mechanisms in dealing withinconsistencies in transactions.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[10]10.
--- Content provided by FirstRanker.com ---
Explain briefly about architectural issues in distributed object DBMS.
--- Content provided by FirstRanker.com ---
[10]OR
11.
--- Content provided by FirstRanker.com ---
Give objective of query processing in view of distributed database.
--- Content provided by FirstRanker.com ---
[10]---oo0oo---
--- Content provided by FirstRanker.com ---