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 R17 2022 February 845AD Distributed Databases Question Paper

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

This post was last modified on 17 March 2023


R17

Code No: 845AD

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


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

Explain with examples various types of data fragmentation.




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


[15]



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

2.a)

Describe the reference architecture of distributed database systems.

b)

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


What are integrity constraints explain in detail.



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






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


[8+7]


3.a)

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


Illustrate with examples query optimization of aggregate functions and parametric
functions.

b)

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


Discuss the process of query optimization.



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






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


[8+7]



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

4.a)

What is query translation? Explain equivalence query transformation.

b)

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


How a global query is transformed into fragment query?



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





[8+7]

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



5.

Define dead lock? Discuss in detail various control organizations for distributed dead lock

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

detection.




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






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






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






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

[15]



6.

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


What is a correct distributed concurrency control mechanism? List some correct distributed
concurrency control mechanism. Prove that time stamp based protocol is correct. [15]


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

7.a)

What is check point? Explain its roles in recovery procedures.

b)

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


List out optimistic methods for distributed concurrency? Explain them in brief.

[7+8]

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



8.

Write a short note on:

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

a) Pointer swizzling



b) Object Migration.

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






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






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






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

[7+8]



---oo0oo---

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