Download JNTUH MCA 5th Sem R13 2017 August 815BQ Distributed Databases Question Paper

R13

Code No: 815BQ

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

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA V Semester Examinations, August - 2017

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

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

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

Part A is compulsory which carries 20 marks. Answer all questions in Part A. Part B
consists of 5 Units. Answer any one full question from each unit. Each question carries
8 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 ? 4 Marks = 20

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

1.a) List and explain the necessary components to build a distributed database.

[4]

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

b) Compare parametric queries with nested queries.

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

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

[4]

c) List out the properties of transactions.

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

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

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

[4]

d) Describe reliability protocols in distributed systems.

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

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

[4]

e) List out the activities of Database administrator.

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

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

[4]

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

PART - B

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

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

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

5 ? 8 Marks = 40

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

2.

What are integrity constraints? Discuss how referential integrity is maintained in a

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

distributed system.

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

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

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

[8]

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

OR

3.

What are the distribution database design issues? Explain with examples.

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

[8]


4.

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

Discuss with a relevant example, how distributed query processing is done using semi
join.

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

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

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

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

[8]

OR

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

5.

What is query processing? Explain various steps in distributed query processing along
with transforming global queries to fragmented queries.

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

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

[8]

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

6.

Discuss the differences in concurrency control and recovery in centralized and distributed
systems.

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

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

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

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

[8]

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

OR

7.

Compare Distributed Deadlock prevention to Distributed Deadlock Avoidance. Explain

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

one scheme of Distributed deadlock Detection and Recovery.

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

[8]


8.

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

How non blocking commitment protocols ensure reliability? Explain with an example.[8]

OR

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

9.

Explain various techniques used for protecting the database against unauthorized access to
a distributed database.

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

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

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

[8]

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

10.

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

Discuss the necessary characteristics a system must satisfy to be considered as an Object
DBMS.

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

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

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

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

[8]

OR

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

11.

Briefly explain various components of object query processor architecture.

[8]

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

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

---oo0oo---