Distributed Databases Question Paper - Dec 17 - Computer Engineering (Semester 6)

6views

written 7.3 years ago by

teamques10 ★ 70k

Distributed Databases - Dec 17

Computer Engineering (Semester 6)

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

Q.1

(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

Q.2

(a) Explain Design issues of Distributed DBMS.

(10 marks) 00

(b) Discuss Allocation of fragments in detail.

(10 marks) 00

Q.3

(a) Explain ACID properties of transaction management.

(10 marks) 00

(b) Discuss different types of Locking Mechanisms.

(10 marks) 00

Q.4

(a) Consider the global schema:

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

Show 2 examples of horizontal fragmentation.
Show 2 examples of Vertical fragmentation.
Show 2 examples of Derived fragmentation.

(20 marks) 00

Q.5

(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

ADD COMMENT EDIT