S OCT 2020
R17
--- Content provided by FirstRanker.com ---
Code No: 845ADJAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
MCA V Semester Examinations, October/ November - 2020
--- Content provided by FirstRanker.com ---
DISTRIBUTED DATABASES
--- Content provided by FirstRanker.com ---
Time: 2 Hours--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
Max. Marks: 75
--- Content provided by FirstRanker.com ---
Answer any five questions
All questions carry equal marks
--- Content provided by FirstRanker.com ---
----1.a)
--- Content provided by FirstRanker.com ---
Explain about Reference Architecture for Distributed Databases.
b)
--- Content provided by FirstRanker.com ---
Write short note on Distribution Transparency.--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[7+8]2.a)
--- Content provided by FirstRanker.com ---
Explain about Parametric Queries in distributed database.b)
Explain about grouping and aggregate function evaluation in distributed database. [7+8]
--- Content provided by FirstRanker.com ---
3.a)
Explain Timestamp based protocol in distributed databases.
--- Content provided by FirstRanker.com ---
b)
Explain Optimistic Methods for Distributed Concurrency Control.
--- Content provided by FirstRanker.com ---
[7+8]
used
--- Content provided by FirstRanker.com ---
4.a)
Explain about the following in Distributed Data base:
--- Content provided by FirstRanker.com ---
i) Check points
--- Content provided by FirstRanker.com ---
ii) Cold Restart.
--- Content provided by FirstRanker.com ---
b)
Explain bout authorization and protection in distributed database.
--- Content provided by FirstRanker.com ---
[7+8]
--- Content provided by FirstRanker.com ---
5.a)Explain about various query processing layers in Distributed Multi-DBMS.
b)
--- Content provided by FirstRanker.com ---
Explain about Object Management Architecture CORBA.
--- Content provided by FirstRanker.com ---
[7+8]
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
6.a)Define Distributed Data base and explain the various features of distributed database.
b)
--- Content provided by FirstRanker.com ---
What is meant by data fragmentation? Explain the Vertical Fragmentation with an
example.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[7+8]
--- Content provided by FirstRanker.com ---
7.a)List out the different components that are used by query optimizer. Explain.
b)
--- Content provided by FirstRanker.com ---
Discuss how an optimization graph can be drawn for a given query.
--- Content provided by FirstRanker.com ---
[7+8]8.a)
--- Content provided by FirstRanker.com ---
Explain two-phase locking protocol in distributed database.b)
Explain Deadlock prevention in distributed databases.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[7+8]
--- Content provided by FirstRanker.com ---
---oo0oo---