Computing Essentials 2017 26th Edition By Oleary – Test Bank

11 Key
1.
(p. 278)
Which view of data deals with how the data is actually formatted and located?
A. Physical view
B. Logical view
C. Information view
D. Technical view
AACSB: Technology
Accessibility: Keyboard Navigation
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 11-01 Distinguish between the physical and logical views of data.
OLeary – Chapter 11 #1
Topic: Data
2.
(p. 279)
A data field that represents a description or characteristic of some entity.
A. Character
B. Attribute
C. Record
D. Entity

3.
(p. 279)
A collection of related fields such as a person’s name, address, and age.
A. Character
B. Record
C. Field
D. File
AACSB: Technology
Accessibility: Keyboard Navigation
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 11-02 Describe how data is organized: characters, fields, records, tables, and databases.
OLeary – Chapter 11 #3
Topic: Data Organization
4.
(p. 280)
A field that uniquely identifies each record.
A. ID
B. Primary key
C. Common
D. Numeric
AACSB: Technology
Accessibility: Keyboard Navigation
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 11-03 Define key fields and how they are used to integrate data in a database.
OLeary – Chapter 11 #4
Topic: Data Organization
5.
(p. 280)
In _______, data from transactions are collected over time and then processed all at once.
A. batch processing
B. group processing
C. real-time processing
D. consignment processing
AACSB: Technology
Accessibility: Keyboard Navigation
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 11-04 Define and compare batch processing and real-time processing.
OLeary – Chapter 11 #5
Topic: Data Organization

6.
(p. 281)
In _______, data is processed at the same time the transaction occurs.
A. batch processing
B. group processing
C. real-time processing
D. consignment processing
AACSB: Technology
Accessibility: Keyboard Navigation
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 11-04 Define and compare batch processing and real-time processing.
OLeary – Chapter 11 #6
Topic: Data Organization
7.
(p. 281)
Having several instances of the same data is called data _______.
A. repetition
B. duplication
C. doubling
D. redundancy
AACSB: Technology
Accessibility: Keyboard Navigation
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 11-05 Describe databases, including the need for databases and database management systems (DBMSs).
OLeary – Chapter 11 #7
Topic: Databases
8.
(p. 281-
282)
If Mr. Smith’s bike has been sent to his new address, but the bill to his old one, it can most likely be
attributed to a lack of data _______.
A. integrity
B. maintenance
C. redundancy
D. administration
AACSB: Analytical Thinking
AACSB: Technology
Accessibility: Keyboard Navigation
Blooms: Analyze
Difficulty: 3 Hard
Learning Objective: 11-05 Describe databases, including the need for databases and database management systems (DBMSs).
OLeary – Chapter 11 #8
Topic: Databases
9.
(p. 282)
Which of the following is not an advantage of using a database?
A. Security
B. Reliability
C. Sharing
D. Data Integrity
AACSB: Analytical Thinking
AACSB: Technology
Accessibility: Keyboard Navigation
Blooms: Apply
Difficulty: 2 Medium
Learning Objective: 11-05 Describe databases, including the need for databases and database management systems (DBMSs).
OLeary – Chapter 11 #9
Topic: Databases
10.
(p. 282)
Analysis tools that support viewing all or selected parts of data, querying the database, and generating
reports include query-by-example as well as a specialized programming language called _______.
A. SQL
B. HTML
C. XML
D. VBA
AACSB: Technology
Accessibility: Keyboard Navigation
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 11-05 Describe databases, including the need for databases and database management systems (DBMSs).
OLeary – Chapter 11 #10
Topic: Databases