Veer Narmad South Gujarat University 2007 M.C.A Distributed Database - - Question Paper
DK-4835 M. C. A. (Sem. V) Examination December - 2007 MCA - 503 : Distributed Databases
Time : 3 Hours] Instruction :
(n?n.nki<al RrhI (3tuuA us
Fillup strictly the details of signs on your answer book. Name of the Examination :
M. C. A. (Sem. 5)
Name of the Subject:
MCA-503 : Distributed Databases
-Subject Code No.: |
|
[Total Marks : 70
Seat No.
-Section No. (1,2......) :| Nil |
1 Answer the following in short : (any four) 12
(a) Differentiate between join and bloomjoin.
(b) Discuss the transaction properties.
(c) Which are the various failures in distributed DBMS ?
(d) How are capture and apply steps implemented in replication ?
(e) Differentiate between replicated database and distributed database.
2 Attempt the following : (any three) 21
(a) Discuss the MDBS architecture without a GCS.
(b) What is fragmentation ? Which are its different types ? Discuss any one.
(c) Discuss about reliability concepts and measures.
(d) Discuss the generic layering scheme for distributed query processing.
DK-4835]
[Contd..
1
Attempt the following : (any thre) 21
(a) What is replication ? How is replication handled in Oracle ?
(b) Discuss the query optimization process.
(c) What is 2PC ? Discuss in brief.
(d) Briefly discuss about Distributed Locking.
Attempt the following : (any two) 16
(a) Discuss about the components of a distributed DBMS.
(b) Discuss about LRM and command execution
(c) Quote and justify a practical application to be a distributed DBMS.
K-4835]
2
[ 200 ]
Attachment: |
Earning: Approval pending. |