M.C.A-M.C.A 5th Sem IT-1 - DISTRIBUTED DATABASE MANAGEMENT SYSTEM(University of Pune, Pune-2013)

M.C.A. (Management Faculty) (Semester - V) Examination, 2013

Management Elective : IT-1 - DISTRIBUTED DATABASE

MANAGEMENT SYSTEM

(2005 Pattern)

Time : 3 Hours                                                                                                             Max. Marks : 70

Note : 1)    Full marks are indicated to the right of each question.

2)   Whenever necessary, state assumptions.

3)   Give examples if required.

4)   Q. No. 7 is compulsory, solve any five from remaining.

1. Explain the need for DDBMS and its advantages and disadvantages.

2. What are the different types of fragmentations ?

3. Explain query optimization, query execution and access plan with suitable

example.

4. Discuss data recovery in case of node and link failure.

5. Discuss the architecture of Heterogeneous DDBMS.

6. Discuss various concurrency control methods in DDBMS.

7. Write a short note on (any 4) :

a) Client server database

b) Distributed Data Administrator

c) Mobile Database

d) Distributed Deadlock

e) Components of DDBMS.

———————

Add comment