Answer each question briefly. If you refer to a source, either cite the text or paraphrase.

1. What is a log file for a database?
2. How does DBMS ensure that a database and log file are consistent?
3. What is one of the main problems of a write lock?
4. What type of lock do you have when many transactions are allowed to read the same data but none are allowed to modify it?
5. True or false: The need to restrict access to data is privacy, and security is what we actually do to maintain privacy.
6. Why does a data warehouse change much less often than a transactional/operational database?
7. Why do data warehouses need to keep historical data instead of simply the most current values?
8. What is the best way for an organization to handle inconsistent data?
9. How can data quality be improved by the use of an audit trail?