How is a lockout different from a deadlock? Give an accounting example to illustrate why a database lockout is necessary and how a deadlock can occur. Provide meaningful table names in your example.
The XYZ Company is a geographically distributed organization with several sites around the country. Users at these sites need rapid access to common data for read only purposes. Which distributed database method is best under these circumstances? Explain your reasoning.
The ABC Company is a geographically distributed organization with several sites around the country. Users at these sites need rapid access to data for transaction processing purposes. The sites are autonomous; they do not share the same customers, products, or suppliers. Which distributed database method is best under these circumstances? Explain your reasoning.