GTU last year question papers -BE- Sem-VIIth -Distributed Database Application and System -May/June- 2012

GTU last year question papers

GUJARAT TECHNOLOGICAL UNIVERSITY

BE- VIIth SEMESTER–EXAMINATION – MAY/JUNE- 2012

Subject code: 171602 

Subject Name: Distributed Database Application and System

 

Instructions:

1. Attempt all questions.

2. Make suitable assumptions wherever necessary.

3. Figures to the right indicate full marks.

Q.1 (a) Explain Following transparency for distributed database.

(1) Network Transparency (2) Replication Transparency

(3) Fragmentation Transparency   

(b) Explain Top Down Design Process for distributed database design.     

Q.2 (a) Explain Layers of Query Processing.     

(b) Describe following operation in context of relation algebra (1) Selection (2)

Intersection (3) _ – Join   

OR

(b) Explain type of networks topology.     

Q.3 (a) Explain Client – Server architecture with figure.     

(b) Describe COM_MIN algorithm used in horizontal fragmentation.     

OR

Q.3 (a) Describe BEA algorithm used in vertical fragmentation.     

(b) List Distribution design issue and explain any one of them.     

Q.4 (a) Explain individual assertion for distributed semantic integrity control.     

(b) Give objective of query processing in view of distributed database.     

OR

Q.4 (a) Explain peer – peer architecture with figure.     

(b) List steps of query decomposition and explain any one from that.     

Q.5 (a) What is query optimization? List components of query optimizer software and

explain any one from that.   

(b) What is normalization? Explain any one normal form.     

OR

Q.5 (a) Explain complicating factors of distributed DBMSs.     

(b) Explain transaction management in DDBMS.     

 

Leave a Comment