1) Explain how Distributed Database System and Centralized database System Differs.
2) Under what circumstances might a Distributed database System not function as well as a centralized Database System?
3) Compare the semi join to the Natural Join.
4) What is the Purpose of a 2 Phase Commit protocol? How does it work?
5) How is database Recovery affected in a distributed database System?
6) What is Distributed database Management System? Define the concept of High Availability and how it offers fault tolerance against machine Failure.
7) What is two-phase locking and how does it guarantee serializability?
8) What are the major differences between a parallel and a distributed system? Describe in detail.
9) Explain the concept of Query Processing. What is a parser? Why it is used?
10) What do you mean by a system log? What is the purpose of the system log in system recovery?