Veer Narmad South Gujarat University 2008 M.C.A Distributed Database -- - Question Paper
M. C. A. (Sem. V) Examination November / December - 2008 MCA-503 : Distributed Databases
Time : 3 Hours] [Total Marks : 70
Instructions :
Seat No.:
Ptsuntaiuft GrttqtA u* <hh41.
Fillup strictly the details of signs on your answer book.
Name of the Examination:
M. C. A. (Sem. 5)
r
Name of the Subject:
MCA-503 : Distributed Databases
Subject Code No. |
|
Section No. (1,2......) |
Student's Signature
Nil
Answer the following in short : (any four)
12
(1) Differentiate between creating shared links for dedicated servers against shared servers.
(2) Discuss various ways how database links can be viewed.
(3) What are the measures for reliability ?
(4) What are distributed transactions ? Explain.
(5) How does a distributed transaction management differ from a centralized one ?
2 Attempt the following : (any three) 21
(1) Discuss the various components of a distributed DBMS with diagram.
(2) Discuss the client/server architecture of a DDBMS.
(3) Discuss the procedure for dropping database links.
(4) Discuss how to change a global name using some examples.
3 Attempt the following : (any three) 21
(1) Discuss the different types of transactions in DDBMS.
(2) How can one manually override in-doubt transactions? Explain.
[Contd..
1
CD-4844]
(3) Discuss the global roles in Oracle and granting privilege to these global roles.
(4) What is replication ? Which are its different types ? Discuss any one.
4 Write notes on following : 16
(1) Which are the design issues for DDBMS ?
(2) Creation of database links.
CD-4844]
2
[ 200 ]
Attachment: |
Earning: Approval pending. |