In a 250- to 500-word document, address the following questions:
- Describe the atomicity, consistency, isolation, and durability (ACID) test, including the meaning of each of the four components. Provide an example that illustrates the importance of adhering to the ACID test.
- Explain “collateral damage” in an update query.
- Explain why locking prevents dirty reads.
- Summarize what happens when you encounter a “Deadlock,” and provide an example of what can be done to correct a deadlock.