1. Record locking is the technique of preventing simultaneous access to data in a database, to prevent ____________________
2. In this classic example (see excerpt below), fill in the blanks with the most appropriate statement.
3. A simple way to prevent the over writing of data is to ______________________________ by any user, so that no other user can save data.
4. Locking a file prevents records from being overwritten incorrectly,and allows only _________________ locking out other users who need to edit records at the same time
5. To allow ___________________________ and also prevent inconsistencies created by unrestricted access, a single record can be locked when retrieved for editing or updating
6. In database management theory, locking is used to implement ___________ among multiple database users. This is the "I" in the acronym ACID
7. Fill in the blanks for the following excerpt
8. In the following example _________________________.
9. Data redundancy is usually the mark of an inefficient database and people go to great lengths to avoid it
10. Data redundancy in a database means that the same data is present in more than one table