Technology In Action Complete 14th Edition By 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) spreadsheet
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) In a database, the term ________ is synonymous with a category of information.
A) field
B) record
C) row
D) table
Answer: A
Diff: 2
Objective: 11.06 Describe how relational databases organize and define data.
6) In a database, a group of related records is referred to as a(n) ________.
A) memo
B) field
C) object
D) table
Answer: D
Diff: 2
Objective: 11.06 Describe how relational databases organize and define data.

7) In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field.
A) text
B) long text
C) short text
D) object
Answer: B
Diff: 2
Objective: 11.06 Describe how relational databases organize and define data.

8) You can set a ________, which is automatically displayed in a field unless the user enters something different.
A) default value
B) relation
C) field type
D) numeric check
Answer: A
Diff: 2
Objective: 11.06 Describe how relational databases organize and define data.

9) Which of the following is a likely primary key in a student information record?
A) Last name
B) Date of birth
C) Student ID number
D) First name
Answer: C
Diff: 1
Objective: 11.06 Describe how relational databases organize and define data.

10) ________ 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.