Chapter 6

Question 1

A grouping of characters into a word or group of words is called​ a(n) ________.

A. bit
B. byte
C. record
D. field
E. file

Answer 1

D. field

Question 2

A​ person, place, or thing that is stored in a database is called​ a(n) ________.

A. bit
B. entity
C. object
D. file
E. attribute

Answer 2

B. entity

Question 3

The coupling of files used to store information and the application program that updates and maintains those files is called​ ________.

A. program-data dependence
B. data redundancy
C. enterprise computing
D. program-data independence
E. client/server computing

Answer 3

A. program-data dependence

Question 4

Data is considered to be​ __________ when the same attribute has different values in different systems.

A. redundant
B. inconsistent
C. dependent upon a program
D. safe
E. cleansed

Answer 4

B. inconsistent

Question 5

A(n) ________ enables an organization to centrally manage and organize data.

A. storage area network
B. laptop computer
C. cloud computer
D. desktop computer
E. database management system

Answer 5

E. database management system

Question 6

The unique identifier for all data in a table is called the​ ________.

A. primary key
B. candidate key
C. foreign key
D. tuple
E. columns

Answer 6

A. primary key

Question 7

In relational​ databases, the​ ________ operation creates a subset of records in the file that meet stated criteria.

A. join
B. truncate
C. project
D. aggregate
E. select

Answer 7

E. select

Question 8

________ use a more flexible data model and are designed for big data.

A. Online analytical processing systems
B. Legacy systems
C. Data warehouses
D. Relational databases
E. Non-relational database management systems

Answer 8

E. Non-relational database management systems

Question 9

A(n) ________ is a database that stores historic and current data for the use of decision makers in the organization.

A data warehouse
B. transaction processing system
C. flat-file system
D. non-traditional database management system
E. in-memory database

Answer 9

A data warehouse

Question 10

An open source framework for parallel processing across inexpensive computers is called​ ________.

A. ​in-memory computing
B. big data
C. Hadoop
D. data warehouse
E. Linux

Answer 10

C. Hadoop

Question 11

________ is another way to facilitate big data analysis and remove bottlenecks normally found in a traditional database.

A. Data analytics
B. Data warehousing
C. In-memory computing
D. Hadoop
E. Online analytic processing​ (OLAP)

Answer 11

C. In-memory computing

Question 12

All the following are types of information that are obtained from data mining EXCEPT​ ________.

A. associations
B. web beacons
C. sequences
D. clustering
E. classification

Answer 12

B. web beacons

Question 13

​A(n) ________ specifies the rules of an organization for sharing and disseminating information.

A. information protocol
B. disaster recovery plan
C. quality assurance plan
D. information policy
E. information toolset

Answer 13

D. information policy

Question 14

Finding hidden patterns and relationships in large databases and inferring rules from them to predict future behavior is called​ ________.

A. a text mining tool
B. a network operation
C. data mining
D. data cleansing
E. a data quality audit

Answer 14

C. data mining

Question 15

A(n) ________ is a structured survey of the accuracy and level of completeness of data in an information system.

A. end-user survey
B. VPN analysis
C. post-mortem analysis
D. data quality audit
E. data consistency audit

Answer 15

D. data quality audit

Question 16

The process of detecting and correcting errors in a database is called​ ________.

A. data transmission
B. data extraction
C. normalization
D. data mining
E. data cleansing

Answer 16

E. data cleansing