M.C.A DEGREE EXAMINATION
DISTRIBUTED DATA BASE SYSTEMS
SECOND YEAR - SECOND SEMESTER
GUESS PAPER

(Effective from the admitted batch of 2000 - 2001)

Time: Three Hours
Maximum: 75 Marks

First Question is compulsory
Answer any FOUR from the remaining questions

All questions carry equal marks.
Write all bits of the first question at one place.

1.
a. What is a Transaction?
b. Write three advantages of distributed databases
c. What is Fragmentation
d. What is relaxed concurrency
e. What are the main Layers of query processing

2. What is a Distributed Database System? Explain briefly about achieving transparencies in distributed DBMS

3. Write a detailed note on Reference architectures in a DDBMS.

4. What is Query Processing? Explain with the help of an example about characterization of query processing

5. Explain design principles of database fragmentation

6.
a. Write about various control algorithms (7)
b. How are deadlocks managed (8)

7. Write about the architecture of transactions.

8. Write a note on the following
a. Design Strategies for DDD
b. Problems with Transactions
c. Sterilizability theory