Download JNTUH MCA 5th Sem R15 2018 June-July 825AC Distributed Databases Question Paper

R15

Code No: 825AC

--- Content provided by FirstRanker.com ---

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

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 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) 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 with
inconsistencies 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 ---