munotes®

Engineering B.E. (Computer Engineering) Sem 6 Distributed Databases Dec 2019 Question Paper - Mumbai University | munotes

Distributed Databases Question Paper, Dec 2019.pdf
CMPN · 59 KB · 1 May 2025

Loading PDF...

Older exam May 2019 Semester-end · Distributed Databases →
Newer exam None yet: this is the latest New papers land after each exam season.

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.

Issue

Something wrong on this page? Report it and we will check it against the scan.

Quick Help

No. The full paper opens straight away, with no login and nothing to pay.

Something wrong with this paper? Report it.

Connected Papers
Engineering / B.E. (Computer Engineering) · 250 papers
Browse all →
Questions? Email contact@munotes.in
Done!
Done!