| Level | Master |
| Programme | ME. CE/ M. Sc. CS |
| Semester | Spring |
| Year | 2019 |
| Course | Distributed Database System |
| Full Marks | 100 |
| Pass Marks | 60 |
| Time | 4 hrs |
Candidates are required to give their answers in their own words as far as practicable.
The figures in the margin indicate full marks.
Attempt all the questions:
1. What is the difference between Centralized and Distributed Database?
Why should today’s e-commerce sites should migrate towards distributed database? (5 + 5)
2. Discuss Horizontal fragmentation and its types with appropriate examples. (10)
3. Discuss the importance of Data Security in Distributed Database and discuss how one can maintain it. (10)
4. Explain Query decomposition and its steps with a suitable example. (10)
5. Write short notes on: (5 + 5)
6. Explain Query optimization and its main components. (10)
7. Explain the concept of serializability and its types. (10)
8. Write short notes on: (5 + 5)
9. With the help of a figure, discuss the function of Local Recovery Manager. (10)
10. Discuss the difference between Parallel DBMS and Distributed DBMS. (10)