Technology In Action Complete 15th Edition By Alan Evans – Test Bank

Chapter 11 Behind the Scenes: Databases and Information Systems

1) A ________ is a collection of related data that can be stored, sorted, organized, and queried.
A) database
B) document
C) memo
D) macro
Answer: A
Diff: 1
Objective: 11.01 Explain what a database is and why databases are useful.

2) If a school keeps two lists, one for student registration and one for student financial information, both containing name and address information, this is an example of data ________.
A) integrity
B) redundancy
C) completeness
D) normalization
Answer: B
Diff: 2
Objective: 11.01 Explain what a database is and why databases are useful.

3) Data ________ means that the data contained in a database is accurate and reliable.
A) efficiency
B) integrity
C) redundancy
D) consistency
Answer: B
Diff: 2
Objective: 11.02 Discuss the benefits of using a database.

4) Data ________ helps to ensure data integrity by maintaining information in only one place.
A) flexibility
B) redundancy
C) mapping
D) centralization
Answer: D
Diff: 2
Objective: 11.02 Discuss the benefits of using a database.

5) ________ is used to ensure that data is organized most efficiently in a database.
A) Consistency checking
B) Validation
C) Normalization
D) Range checking
Answer: C
Diff: 2
Objective: 11.02 Discuss the benefits of using a database.
6) ________ databases are the most commonly used electronic databases.
A) Relational
B) Flat-file
C) Multidimensional
D) Object-oriented
Answer: A
Diff: 3
Objective: 11.03 Describe features of relational databases.

7) A ________ relationship indicates that for each record in a table, there is only a single corresponding record in a related table.
A) many-to-one
B) one-to-many
C) one-to-one
D) many-to-many
Answer: C
Diff: 1
Objective: 11.03 Describe features of relational databases.

8) Nontraditional data in object-oriented databases such as audio clips, video clips, pictures, and very large documents are called ________ data.
A) enterprise
B) structured
C) unstructured
D) multidimensional
Answer: C
Diff: 3
Objective: 11.04 Describe features of object-oriented databases.

9) Data in a multidimensional database is organized in a ________ format.
A) linear
B) modular
C) cube
D) cellular
Answer: C
Diff: 2
Objective: 11.05 Describe features of multidimensional databases.

10) In a database, the term ________ is synonymous with a category of data.
A) field
B) record
C) row
D) table
Answer: A
Diff: 2
Objective: 11.06 Describe how relational databases organize and define data.