Engineering BE Computer Engineering Sem 6 December 2019 2019 Distributed Databases Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 a) Define Distributed Database System? of it? 5 marks
   • b) Explain Distributed Database Design Issues? 5
   • c) Compare homogenous and heterogeneous databases? 5
   • d) List applications of XML. 5
2. Q2 a) Draw and Explain Model of Transaction Management in DDB. 10 marks
   • b) Describe clearly Two Phase Commit (2PC) Protocol. 10
3. Q3 a) Explain any one Timestamp Based Concurrency Control Mechanisms in DDB. 10 marks
   • b) Explain types of fragmentation?, Perform. Primary Horizontal Fragmentation of relation Department looking for departments located at different site and accesses department information according to site access <=30,0000 and other site
4. Q4 a) University Database contains information about the course and the Professors who teach the each semester. Each course also have information about the number of student enrolled, room no., date and time (when and where the course
   • i. Create an XML Schema (.xsd) for above XML documents
   • ii.) Write XQuery for the following: Retrieve Course name which was conducted
   • b) What are the various kinds of transparencies in distributed database design? Explain each with the help of an example 10
5. Q5 a) Explain Phases in Distributed Query Processing in Distributed Database? 10 marks
   • b) Wait Die and Wound Wait Method with the help of an example? 10
6. Q6 a) Explain Distributed Database Architecture with neat diagram. 10 marks
   • b) and Explain anomalies of Concurrency Control in distributed system? 10

Read from the scan above, so a character or two may differ. The scan is the original.