Download JNTUH MCA 5th Sem R15 2019 December 825AC Distributed Databases Question Paper

R15

Code No: 825AC

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

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA V Semester Examinations, December - 2019

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

DISTRIBUTED DATABASES

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

Time: 3 Hours

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

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

Max. Marks: 75

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

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

1.a) Distinguish between distributed versus centralized databases.

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

[5]

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

b) What is an operator tree of a query? Explain the use of operator graph.

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

[5]

c) What do you mean by distributed transaction? Explain.

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

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

[5]

d) What are the design issues of a reliable distributed database?

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

[5]

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

e) What is pointer swizzling? Explain its advantages and disadvantages.



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

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

What is referential integrity? Give an example.

b)

Write the criteria used for checking correctness of fragmentation.

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

[5+5]

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

OR

3.

Given a global relation:

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

EMP (EMPNUM, NAME, SAL, TAX, MGRNUM, DEPTNUM).

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

Write the mixed fragmentation definition and fragmentation tree of relation EMP.[10]

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

4.a)

How fragmented relation simplification is done? Explain.

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

b)

What is the use of algebra of qualified relations? Discuss.

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

[5+5]

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

OR

5.

Explain the following for distributed databases.

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

a) Operations in a parametric query

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

b) GROUP by operation for evaluating aggregate functions.

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

[5+5]

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

6.

Explain in detail various methods used for deadlock detection.

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

[10]

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

OR

7.a)

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

Write about computational structure of distributed transaction.

b)

What is serializability? Illustrate this concept with an example.

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

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

[5+5]


8.

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

Explain about quorum based commitment protocols.

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

[10]

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

OR

9.

Discuss object naming and catalog management with site autonomy.

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

[10]

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

10.a) What are the issues related to query processing and optimization in object DBMS?

Discuss.

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

b) Explain object query processor architecture.

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

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

[5+5]

OR

11.a) Define type lattice and its management.

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

b) Explain the management of composition graph.

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

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

[5+5]



---ooOoo---

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