Download JNTUH MCA 5th Sem R15 2022 February 825AC Distributed Databases Question Paper

R15

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

Code No: 825AC

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA V Semester Examinations, February - 2022

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

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

Answer any Five Questions

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

All Questions Carry Equal Marks

- - -

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

1.a) Explain the features of distributed databases over centralized databases.
b) What is fragmentation? Explain.

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

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

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

[8+7]



2.

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

With a neat diagram explain the reference architecture for distributed databases. [15]

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

3.

Explain the following.

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

a) Parametric queries.

b) semi join reduction.

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

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

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

[8+7]

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

4.

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

Discuss about the framework for query optimization.

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

[15]

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

5.

Discuss about distributed deadlocks.

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

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

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

[15]



6.

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

What is transaction? With suitable examples explain ACID properties. What are the goals
of transaction management?

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

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

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

[15]

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

7.a) Discuss in detail about checkpoints.
b) What are the design issues of a reliable distributed database?

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

[8+7]

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

8.a) Explain about pointer swizzling.
b) Write about transaction management in object DBMS.

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

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

[7+8]

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

---oo0oo---