Download JNTUH MCA 5th Sem R17 2021 February 845AD Distributed Databases Question Paper

R17

Code No: 845AD

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

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

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

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

MCA V Semester Examinations, February - 2021

DISTRIBUTED DATABASES

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

Time: 2 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.

Explain the reference architecture for distributed databases.

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

[15]

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

2.a)

What is the criteria for checking the correctness of fragmentation? Explain.

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

b)

What are integrity constraints? Explain with examples.

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

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

[7+8]

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

3.

Explain global query optimization using distributed data manager method.

[15]

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

4.a)

How fragmented relation simplification is done? Explain.

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

b)

Explain about semi-join reduction in distributed databases.

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

[8+7]

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

5.

Prove that 2-phase locking is a correct distributed concurrency control method. [15]

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

6.a)

Explain about log-write-ahead protocol.

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

b)

State on the validity of serializability as a correctness criterion.

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

[7+8]

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

7.a)

Explain quorum-based commitment protocols.

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

b)

With examples, explain how to detect inconsistencies in distributed databases.

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

[7+8]


8.a)

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

Write about detection based cache consistency algorithms.

b)

Explain attribute-to-entity transformation with an example.

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

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

[8+7]

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

---oo0oo--