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 R15 2019 April-May 825AC Distributed Databases Question Paper

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

This post was last modified on 17 March 2023


R15

Code No: 825AC

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

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA V Semester Examinations, April/May - 2019

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

Note: This question paper contains two parts A and B.

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


Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part B
consists of 5 Units. Answer any one full question from each unit. Each question carries
10 marks and may have a, b, c as sub questions.

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



PART - A


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






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






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






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



5 ? 5 Marks = 25


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


1.a) Discuss the relative advantages of centralized and distributed databases.

[5]

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

b) Discuss about translation of global queries into fragmented queries.



[5]

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


c) Explain Deadlocks in distributed database.



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






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


[5]

d) Explain about 3-phase commitment protocol.

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






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




[5]

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

e) Explain about multi database concurrency control.




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




[5]

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



PART - B


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






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






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






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

5 ? 10 Marks = 50

2.a)

Explain how to differ the following : fragmentation transparency, replication

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

transparency and location transparency.

b)

What is meant by data fragmentation in distributed database?

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






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

[5+5]

OR

3.a)

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


Explain about integrity constraints in distributed database.

b)

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

Explain reference architecture for distributed databases.




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




[5+5]

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


4.a)

Discuss how query optimization is done using AHY algorithm.

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

b)

Explain the Framework for Query Optimization.


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






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



[5+5]

OR

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


5.a)

Explain about Parametric Queries in distributed database.

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

b)

Explain about the Evaluation of Aggregate Function.


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






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

[5+5]


6.a)

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

Explain Deadlock prevention in distributed databases.

b)

Explain the deadlock detection in distributed database.

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






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



[5+5]

OR

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


7.a)

Explain about the serilizability in distributed database.

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

b)

Explain about conservative time stamp method.


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






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



[5+5]


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

8.a)

Explain about 2-phase commitment protocol.

b)

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


Discus about quorum based 3-phase commitment protocol.



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



[5+5]

OR

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


9.a)

Explain check points and cold restart in distributed database.

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

b)

Discuss about distributed database administration.


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






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

[5+5]


10.a) Explain about Distributed Component Object Model.
b) Explain the transaction management in Object DBMS.

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






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



[5+5]

OR

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


11.a) Explain the Delivery Schedule Algorithm in Push-based Technologies.
b) Discuss between scheme Translation and scheme Integration.


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




[5+5]

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



---ooOoo---