--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD
MCA V Semester Examinations, February - 2022
--- Content provided by FirstRanker.com ---
ADVANCED DATABASES
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 ---
Answer any five questions
All questions carry equal marks
--- Content provided by FirstRanker.com ---
- - -1.
--- Content provided by FirstRanker.com ---
Distributed databases have many advantages; discuss the promises of DDBS technology.--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[15]
--- Content provided by FirstRanker.com ---
2.
Describe a framework for top-down design process for distributed database.
--- Content provided by FirstRanker.com ---
[15]
--- Content provided by FirstRanker.com ---
3.Provide a generic layering scheme for query processing and discuss the functions of
layers.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[15]
--- Content provided by FirstRanker.com ---
4.a)
What do you mean by localization of data?
--- Content provided by FirstRanker.com ---
b)
Differentiate between join and semi-join operation.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[7+8]
5.
--- Content provided by FirstRanker.com ---
Compare the communication structure of centralized 2PL with distributed 2PL. [15]
--- Content provided by FirstRanker.com ---
6.a)Discuss the basic idea behind conservative time-stamp ordering algorithm.
b)
--- Content provided by FirstRanker.com ---
What policies are followed for deadlock avoidance in distributed databases?
[8+7]
--- Content provided by FirstRanker.com ---
7.
What are the advantages of parallel database system? Discuss a general architecture of a
--- Content provided by FirstRanker.com ---
parallel database system.--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[15]
--- Content provided by FirstRanker.com ---
8.Explain the class partitioning algorithms.
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
[15]
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
---oo0oo---