| 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)
- INFRES algorithm
- System R
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)
- Lock-Based Protocols
- Timestamp – Based Protocols
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)