FirstRanker Logo

FirstRanker.com - FirstRanker's Choice is a hub of Question Papers & Study Materials for B-Tech, B.E, M-Tech, MCA, M.Sc, MBBS, BDS, MBA, B.Sc, Degree, B.Sc Nursing, B-Pharmacy, D-Pharmacy, MD, Medical, Dental, Engineering students. All services of FirstRanker.com are FREE

📱

Get the MBBS Question Bank Android App

Access previous years' papers, solved question papers, notes, and more on the go!

Install From Play Store

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

This post was last modified on 17 March 2023


R19

Code No: 865AG

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






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






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



JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA V Semester Examinations, February - 2022

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


ADVANCED DATABASES

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 ---


Answer any five questions

All questions carry equal marks

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

- - -


1.

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

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




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






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






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






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




[15]

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



2.

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

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


[15]



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

3.

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

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






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






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






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




[15]

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



4.a)

What do you mean by localization of data?

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


b)

Differentiate between join and semi-join operation.

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






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


[7+8]


5.

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


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



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

6.a)

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

b)

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


What policies are followed for deadlock avoidance in distributed databases?

[8+7]

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



7.

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

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

parallel database system.




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






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






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


[15]



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

8.

Explain the class partitioning algorithms.


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






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





[15]

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






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

---oo0oo---