Veer Narmad South Gujarat University 2008 M.C.A Distributed Databases-il-- - Question Paper
M. C. A. (Sem. V) Examination April / May - 2008 MCA - 503 : Distributed Databases
Time : 3 Hours] [Total Marks : 70
1 Answer the folllowing in short (any four) 12
(1) What is a distributed database system ?
(2) Which are the various transaction models ?
(3) What are the measures for reliability ?
(4) List the characteristics of a query processor.
(5) How does a distributed transaction management differ from a centralized one ?
2 Attempt the following (any three) : 21
(a) Discuss the various components of a distributed DBMS with diagram.
(b) Discuss the MDBS architecture with a GCS.
(c) Discuss various layers of query processing in DDBMS.
(d) Discuss distributed recovery process.
R-4835]
1
[Contd..
3 Attempt the following (any three) : 21
(a) Discuss the different types of transactions in DDBMS.
(b) Discuss the global roles in Oracle and granting privilege to these global roles.
(c) Discuss failures in distributed DBMS.
(d) What is replication ? Which are its different types ? Discuss any one.
4 Write notes on following (any two) : 16
(a) Which are the design issues for DDBMS ?
(b). 2PC
(c) Deadlock management.
[ 200 ]
2
R-4835]
Attachment: |
Earning: Approval pending. |