Download JNTUH MCA 5th Sem R17 2021 July-August 845AD Distributed Databases Question Paper

Download JNTUH (Jawaharlal nehru technological university) MCA (Master of Computer Applications) 5th Sem (Fifth Semester) Regulation-R17 2021 July-August 845AD Distributed Databases Previous Question Paper

R17

Code No: 845AD















JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

2021 MCA V Semester Examinations, July/August - 2021

DISTRIBUTED DATABASES

Time: 3 Hours















Max.Marks:75

Answer any five questions

All questions carry equal marks

- - -


1.

What is Distributed Database? List and briefly explain advantages of Distributed
database with centralized approach.











[15]



2.

Define Transparency. Explain in detail about the layers of transparencies in distributed
database design.

















[15]


3.a)

Discuss how query optimization is useful in distributed databases.

b)

Explain about Semi-joins with example.











[8+7]



4.

What is meant by semantic query optimization? How does it differ from other query
optimization techniques?















[15]


5.

What is Transaction? Explain the properties of Transactions with example.

[15]



6.

Explain different optimistic methods for distributed concurrency control.

[15]


7.

Explain the following
a) Checkpoints



b) Cold Restart.









[7+8]



8.

Explain about Transaction and Computation Model for Distributed Multi-DBMS in
detail with an example.















[15]





---oo0oo---