Download JNTUH MCA 5th Sem R19 2022 February 865AG Advanced Databases Question Paper

Download JNTUH (Jawaharlal nehru technological university) MCA (Master of Computer Applications) 5th Sem (Fifth Semester) Regulation-R19 2022 February 865AG Advanced Databases Previous Question Paper

R19

Code No: 865AG













JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA V Semester Examinations, February - 2022

ADVANCED DATABASES

Time: 3 Hours













Max.Marks:75



Answer any five questions

All questions carry equal marks

- - -


1.

Distributed databases have many advantages; discuss the promises of DDBS technology.






















[15]



2.

Describe a framework for top-down design process for distributed database.

[15]



3.

Provide a generic layering scheme for query processing and discuss the functions of
layers.



















[15]



4.a)

What do you mean by localization of data?

b)

Differentiate between join and semi-join operation.







[7+8]


5.

Compare the communication structure of centralized 2PL with distributed 2PL. [15]



6.a)

Discuss the basic idea behind conservative time-stamp ordering algorithm.

b)

What policies are followed for deadlock avoidance in distributed databases?

[8+7]



7.

What are the advantages of parallel database system? Discuss a general architecture of a
parallel database system.















[15]



8.

Explain the class partitioning algorithms.











[15]





---oo0oo---