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 2018 January 825AC Distributed Databases Question Paper

Download JNTUH (Jawaharlal nehru technological university) MCA (Master of Computer Applications) 5th Sem (Fifth Semester) Regulation-R15 2018 January 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, January - 2018

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

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



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

Part A is compulsory which carries 25 marks. Answer all questions in Part A. Part B

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

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

1.a)

What is replication transparency? What is its significance?

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






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

[5]

b)

Demonstrate the use of parametric queries.

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






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





[5]

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


c)

What is a nested transaction? Quote examples.

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






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




[5]

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

d)

Define reliability. How to measure reliability of a system?


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




[5]

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

e)

Give object query processor architectures.


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






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





5 ? 10 Marks = 50

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


2.

With necessary reference structure explain various levels of distribution transparency.
Quote an example application.

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






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






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




[10]

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

OR

3.

What is an integrity constraint? What is its importance in distributed databases? Explain

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

with suitable examples.




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






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






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


[10]



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

4.

How can qualified relations optimize query processing in distributed databases? Give
illustrative examples.

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






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






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





[10]

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


OR

5.

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

Describe a frame work for query optimization and explain general queries optimization.




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






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






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






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




[10]

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


6.a)

Explain the architectural aspects of distributed transactions.

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

b)

Give any one protocol for optimistic methods for concurrency control.


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


[5+5]

OR

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

7.

What is a deadlock in distributed databases? Suggest various ways of handling them with
illustrations.

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






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






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






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


[10]



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

8.

Explain two-phase commit protocol and compare it with three-phase commit protocols.[10]

OR

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


9.

What are the various approaches to detect inconsistencies in distributed databases data?
Explain any one resolution method.

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






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






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


[10]



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

10.

Does common object request broker architecture provide interoperability? Justify your
answer with necessary discussions.

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






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






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

[10]

OR

11.

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


Explain transaction management in multi database system. Discuss challenges faced here
compared to centralized database.


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






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






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


[10]



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

---oo0oo---