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
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
(b) Explain type of networks topology.
Q.3 (a) Explain Client – Server architecture with figure.
(b) Describe COM_MIN algorithm used in horizontal fragmentation.
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.
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.
Q.5 (a) Explain complicating factors of distributed DBMSs.
(b) Explain transaction management in DDBMS.