IIT: Chapter 10 – Database Management

I. True/False

1. True
2. False
3. False
4. True
5. False
6. False
7. True
8. True
9. False
10. True

II. Multiple Choice

1. B. Timely
2. A. composite key
3. D. File maintenance
4. B. determines whether a number is within a specified range
5. A. less complexity
6. B. data dictionary
7. B. principle of least privilege
8. A. decides on the proper placement of fields

III. Matching

1. Field name – (e) Uniquely identifies each field.
2. Field size – (g) Defines the maximum number of characters a field can contain.
3. Data type – (c) Specifies the kind of data a field can contain and how the field is used.
4. Primary key – (b) Field that uniquely identifies each record in a file.
5. Query language – (j) Consists of simple, English-like statements that allow users to specify the data to display, print, or store.
6. Log – (a) Listing of activities that modify the contents of a database.
7. Recovery utility – (i) Uses the logs and/or backups to restore a database when it becomes damaged or destroyed.
8. GIS – (d) Database that stores maps and other geographic data.
9. Data modeler – (h) Person who focuses on the meaning and usage of data.
10. Database administrator – (f) Creates and maintains the data dictionary, manages security of the database, monitors the performance of the database, and checks backup and recovery procedures.