CHAPTER 11

Question 1

A column in a database in which customer names are stored would be referred to as a __________.

Answer 1

field

Question 2

Fuzzy logic uses __________.

Answer 2

probablity

Question 3

The field in a table that uniquely identifies each record in that table and relates that table to other tables is called the ___________.

Answer 3

primary key

Question 4

Ray Kurzweil predicts the Singularity might occur by ____.

Answer 4

2045

Question 5

A system designed to help keep track of everyday business activities is a(n) _____________.

Answer 5

Transaction Processing System

Question 6

The world’s largest ERP software company is called

Answer 6

SAP

Question 7

Big Data refers to

Answer 7

Large amounts of data generated today

Question 8

Employees’ last name would usually make an appropriate primary key field.

Answer 8

False

Question 9

In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field.

Answer 9

Long text

Question 10

________ is the branch of computer science that attempts to create computers that think like humans.

Answer 10

Artificial intelligence

Question 11

________ involves taking data from your database and putting it into an electronic file in a format that another external application or database can recognize.

Answer 11

exporting

Question 12

In a transaction-processing system (TPS), if the TPS database can be queried and updated while the transaction is taking place, this is called ________ processing.

Answer 12

bath processing

Question 13

A(n) ________ check determines whether a required field such as LastName was filled in.

Answer 13

Completeness

Question 14

Data ________ means that the data contained in a database is accurate and reliable.

Answer 14

redundancy

Question 15

Management information systems (MIS) provide ________ reports, which show conditions that are unusual or need attention from users of the system.

Answer 15

detail

Question 16

Management information systems (MIS) provide ________ reports, which show conditions that are unusual or need attention from users of the system.

Answer 16

exception

Question 17

When is a flat database sufficient to use when organizing data?

Answer 17

When the data is simple and can be organized in one table

Question 18

A customer information table linked to a password table in a business database reflects which type of relationship?

One-to-many

Many-to-one

Many-to-many

One-to-one

A process to ensure that data in a database is organized most efficiently is called

centralization.

data staging.

normalization.

integration.

Which of the following is not considered metadata?

Data type

Database name

Field name

Field size

Data captured as users navigate through a website is called

staged data.

web-user data.

time-variant data.

Answer 18

One-to-one

Question 19

A process to ensure that data in a database is organized most efficiently is called

Answer 19

normalization

Question 20

Which of the following is not considered metadata?

Answer 20

Database name

Question 21

Data captured as users navigate through a website is called

Answer 21

stage data

Question 22

The type of database that would be best to store and organize data with feature and measure attributes is which of the following?

Answer 22

Multidimensional database

Question 23

Which of the following is used to create a subset of data that matches certain criteria and that can be saved for future reference or use?

Answer 23

Query

Question 24

Which of the following data-mining techniques is used to create charts and dashboards?

Answer 24

Visualization

Question 25

Unnecessary duplication of data in a database is referred to as

Answer 25

Data redundancy

Question 26

Which of the following is a method of inputting data into a transaction-processing system while the transaction is taking place?

Answer 26

Real-time processing