Jawaharlal Nehru Technological University Hyderabad 2007 M.C.A Computer Aplications DISTRIBUTED DATABASES - Question Paper

1. elaborate the features of Distributed data base (DDBS) and Centralized data base? discuss with neat block diagram. Bring out 2 advantages of DDBS over centralized database.
2. What is data fragmentation? elaborate the kinds of fragmentation?
3. What is a transaction? discuss with an example. Differentiate ranging from database consistency and transaction consistency.
4. discuss Timestamp based concurrency control algorithm.
5. elaborate the concepts of reliability in DDBS? How do you measure the consistency of DDBS?
6. elaborate the general failures in DDBS? elaborate the recovery methods adopted?
7. provide a block diagram of any commercially available DDBS. Compare 5 main features of INGRESS and ORACLE systems. provide query optimization algorithm adopted in INGRESS system.
8. discuss the following:
(a) Deadlocks
(b) Atomicity of distributed transaction
(c) Checkpoints for checking inconsistency
(d) Failure transparency.

Earning:   Approval pending.