Veer Narmad South Gujarat University 2007 M.C.A Distributed Database - - Question Paper
M. C. A. (Sem. V) Examination May / June - 2007 MCA - 503 : Distributed Databases
Time : 3 Hours]
[Total Marks : 70
Seat No.
Instructions :
Rwrtl <3tUci*A H* filHeft.
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.: |
|
-Section No. (1,2,.....): |
Student's Signature
Nil
Answer the following in short : (any four)
12
(i) Which are the various phases in a distributed transaction?
(ii) When would a distributed transaction?
(iii) How does a distributed transaction management differ from a centralized one?
(iv) Explain how query is processed in a distributed database application.
(v) Which are the two phases involved during update transaction in a DDBMS?
Attempt the following : (any three) 21
(a) Which are the various distributed architectures? Discuss any one of them.
(b) What is the TCSEC policy? Discuss in brief.
(c) Discuss the issues concerned with Distributed Locking.
(d) Discuss Fragmentation under DDBMS design.
Attempt the following : (any three) 21
(a) How would referential integrity be preserved in a Distributed System?
R-4833]
1
[Contd..
(b) Discuss the properties of transactions.
(c) Discuss the observations on 2PC.
(d) Discuss the different types of transactions in DDBMS.
4 Attempt the following : (any two) 16
(a) Data Warehousing
(b) Distributed Database and Database Replication
(c) Setting up security using Oracle Security Server.
2
R-4835]
Attachment: |
Earning: Approval pending. |