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

Download JNTUH (Jawaharlal nehru technological university) MCA (Master of Computer Applications) 5th Sem (Fifth Semester) Regulation-R15 2022 February 825AC Distributed Databases Previous Question Paper

R15

Code No: 825AC

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA V Semester Examinations, February - 2022

DISTRIBUTED DATABASES



Time: 3 Hours















Max. Marks: 75

Answer any Five Questions

All Questions Carry Equal Marks

- - -


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













[8+7]



2.

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



3.

Explain the following.



a) Parametric queries.

b) semi join reduction.















[8+7]



4.

Discuss about the framework for query optimization.







[15]


5.

Discuss about distributed deadlocks.











[15]



6.

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













[15]



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





[8+7]



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







[7+8]





---oo0oo---