Question Paper: Distributed Databases Question Paper - Dec 17 - Computer Engineering (Semester 6) - Mumbai University (MU)

Distributed Databases - Dec 17

Computer Engineering (Semester 6)

Total marks: 80
Total time: 3 Hours
(1) Question 1 is compulsory.
(2) Attempt any three from the remaining questions.
(3) Draw neat diagrams wherever necessary.


(a) What are the different deadlock avoidance techniques?
(5 marks) 00

(b) What are the approaches for global query optimization ?
(5 marks) 00

(c) Compare federated databases with non-federated databases.
(5 marks) 00

(d) What are the Concurrency Control Anomalies?
(5 marks) 00


(a) Explain Design issues of Distributed DBMS.
(10 marks) 00

(b) Discuss Allocation of fragments in detail.
(10 marks) 00


(a) Explain ACID properties of transaction management.
(10 marks) 00

(b) Discuss different types of Locking Mechanisms.
(10 marks) 00


(a) Consider the global schema:

PATIENT(Number, name, UID, Amount_due, Dept, Doctor, Med_treatment)
DEPARTMENT (Dept, Location, Director)
STAFF (Staffnum, Director, Task).

  1. Show 2 examples of horizontal fragmentation.
  2. Show 2 examples of Vertical fragmentation.
  3. Show 2 examples of Derived fragmentation.
(20 marks) 00


(a) Explain different Types of Failures in a Distributed Database System.
(10 marks) 00

(b) Design XML DTD file and XML document file for the following relational schema:

$\hspace{20mm}$customer(cname, cresidence, ctel)
$\hspace{20mm}$item(item-name, item-code)
$\hspace{20mm}$order-request(customer, set of product)
$\hspace{20mm}$ctel can be a residence number or a mobile number.

(10 marks) 00

Q.6 Write notes on the following. (any two) $\hspace{10mm}$ [10$\times$2]

$\hspace{10mm}$(a) Reference Architecture of Distributed DBMS.
(5 marks) 00

$\hspace{10mm}$(b) Objectives of query processing.
(5 marks) 00

$\hspace{10mm}$(c) 3PC recovery protocols.
(5 marks) 00

$\hspace{10mm}$(d) Querying and transformation of XML data.
(5 marks) 00

modified 5 months ago by gravatar for Yashbeer Yashbeer160 written 5 months ago by gravatar for tanya.tanyabarnwal tanya.tanyabarnwal0
Please log in to add an answer.