Make your own free website on
Practice Test

Grace's Chapter 7 Study Guide

Correct answers in GREEN. Your answers in BLUE.
Review Page
1. An integrated collection of data that can include seemingly unrelated information, no matter where it is stored in the company is a _____.
A: data dictionary
B: network warehouse
C: data warehouse
D: company data structure
2. A common field refers to _____.
A: a set of related fields that describes one instance
B: a set of related records that store data about a specific identity
C: a field that uniquely and minimally identifies a particular member of an entity
D: an attribute that appears in more than one entity
3. A _____ contains records that contain day-to-day business and operational data.
A: transaction file
B: work file
C: table file
D: master file
4. A set of one or more fields that can occur any number of times in a single record, which each occurrence having different values is referred to as _____.
A: a repeating group
B: an order group
C: a normalized group
D: none of the above
5. _____ are used in HTML to specify how the text and visual elements will be displayed in a Web browser.
A: Posts
B: Flags
C: Tags
D: Signs
6. A framework for organizing and storing data is a _____.
A: business structure
B: file table
C: system table
D: data structure
7. The _____ does NOT consist of a unique value.
A: primary key
B: secondary key
C: combination key
D: multi-valued key
8. A(n) _____ is a person who typically manages a DBMS.
D: none of the above
9. A natural extension of the object-oriented analysis process is the _____.
A: relational database
B: hierarchical database
C: object compatible database
10. Middleware refers to _____.
A: software that integrates different applications
B: software that allows applications to exchange data
C: software that interprets client requests in HTML form and translates the requests into executable commands
D: all of the above
11. A _____ stores relatively permanent data about an entity.
A: table file
B: master file
C: work file
D: history file
12. The process of creating table designs by assigning specific files or attributes to each table in the database is _____.
A: compatibility
B: referential integrity
C: cardinality
D: normalization
13. _____ is a characteristic of Web-based database design.
A: Global access
B: Multiple platforms
C: Adaptability issues
D: all of the above
14. A coding method that represents characters as integers, using 16 bits per character is _____.
C: Unicode
D: binary storage format
15. A _____ describes any field that could serve as a primary key.
A: multi-valued key
B: composite key
C: secondary key
D: candidate key
16. Scalability refers to _____.
A: a system can be modified, expanded, or down-sized easily to meet changing needs
B: data can be shared across the enterprise, allowing more users access to more data
C: consistent standards are set for data names, formats, and documentation
D: systems are relatively independent of how the physical data is maintained
17. When creating a database, the first step is to _____.
A: create 3NF designs for all tables
B: create the initial ERD
C: verify all data dictionary entries
D: assign all data elements to entities
18. Intranets and extranets use the same protocols as the Internet; they are called _____.
A: Web-centric
B: externally aligned
C: frame compatible
D: HTML-based
19. _____ is NOT a potential problem that exists in a file-processing environment.
A: A rigid data structure
B: Data integrity
C: Master file storage
D: Data redundancy
20. A _____ relationship has an associative entity with its own characteristics.
A: 1:1
B: M:N
C: 1:M
D: all of the above