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

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

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


2021 MCA V Semester Examinations, July/August - 2021

DISTRIBUTED DATABASES

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

Time: 3 Hours




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






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






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


Max.Marks:75

Answer any five questions

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

All questions carry equal marks

- - -


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

1.

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

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






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






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

[15]



2.

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


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


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






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






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






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

[15]


3.a)

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

Discuss how query optimization is useful in distributed databases.

b)

Explain about Semi-joins with example.

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






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






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


[8+7]



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

4.

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

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






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






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





[15]

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



5.

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

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


[15]



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

6.

Explain different optimistic methods for distributed concurrency control.

[15]

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



7.

Explain the following

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

a) Checkpoints



b) Cold Restart.

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






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





[7+8]

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




8.

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

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



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






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






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



[15]


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




---oo0oo---

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