M.Tech I Semester Regular Examinations February 2014

Code:9D58106b M.Tech I Semester Regular Examinations February 2014 DISTRIBUTED DATABASES (Common to CSE &CS) (for students admitted in 2013 only) Time :3 hours Max.Marks:60 Answer any five questions All questions carry equal marks 1. Explain with example centralized & distri buted database.Explain advantages and dis advantages of them.
2. What do you mean by database fragmentation? Explain with example.
3. How global queries are handled in distributed environment?
4. Discuss various strategies for query optimization.
5. Apply transation properties for the banking database.
6. How deadlock occurs in distributed environment? How it is handled?
7. Explain in detail non blocking commitment protocol.
8. Discuss distributed transaction management in ‘TanDEM Encompass system’.
*****