Chapter 11 (notes 1)

question

Database
answer

A ________ is a collection of related data that can be stored, sorted, organized, and queried.
question

Redundancy
answer

If a business keeps two lists, one for employee payroll and one for employee benefits information, both containing name and address information, this is an example of data ________.
question

Integrity
answer

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

Data centralization
answer

helps to ensure data integrity by maintaining information in only one place.
question

Database information cannot be changed once it is entered.
answer

Which of the following is NOT a typical disadvantage associated with databases?
question

Administrator
answer

individual trained in the design and building of databases is called a database ________.
question

Implementing data mining
answer

Which of the following is NOT a main operation of a database management system (DBMS)?
question

Data management system
answer

What does the acronym DBMS stand for?
question

Access
answer

Microsoft ________ is a database management system.
question

Field
answer

In a database, a ________ is synonymous with a category of information.
question

Record
answer

In a database, a ________ is a group of related fields.
question

Table
answer

In a database, a group of related records is called a(n) ________.
question

Numeric
answer

In a database, ________ fields store numbers used to perform calculations.
question

Object
answer

In a database, a chart is stored in a(n) ________ field.
question

Hyperlink
answer

A Web address is stored as a(n) ________ field in a database.
question

99999
answer

If a numeric field has a size of 5, which is the highest number it can hold?
question

Data dictionary
answer

A database schema is also called a(n) ________.
question

Dictionary
answer

Prior to entering data into a database, you must create a data ________ entry for each field in the database.
question

Field
answer

________ size defines the maximum number of characters or digits that a particular field can hold.
question

Default value
answer

A ________ is automatically displayed in a field unless the user enters something different.
question

Street address
answer

Which of the following is NOT a likely primary key?
question

Normalization
answer

________ is the process of reducing data redundancy by recording data only once.
question

Primary key
answer

Each record must have a unique field called a(n) ________ field.
question

Relational
answer

____ databases have the largest market share among the primary types of electronic databases.
question

A link between tables that defines how the data are related
answer

In a relational database, what is a relationship?
question

One-to-one
answer

A ________ relationship indicates that for each record in a table, there is only a single corresponding record in a related table.
question

Referential integrity
answer

________ means that for each value in the foreign key of one table, there is a corresponding value in the primary key of another table.
question

Unstructured
answer

Nontraditional data such as audio clips, video clips, pictures, and very large documents are called ________ data.
question

binary large objects (BLOBs
answer

Unstructured data such as video clips and pictures are known as ________ because of the way they are encoded.
question

They store data in table format
answer

Which of the following statements about object-oriented databases is FALSE?
question

Cube
answer

Data in a multidimensional database is organized in a ________ format.
question

Range
answer

A ________ check allows you to set credits allowed for students during one quarter from 0 to 21.
question

Completeness
answer

A(N) ________ check determines whether all required fields were filled in.
question

Consistency
answer

A ________ check compares the values of data in two or more fields to see whether those values are reasonable.
question

Filter
answer

A ________ temporarily displays records that match the specified criteria.
question

Query
answer

A(n) ________is a way of retrieving information from one or more tables that defines a particular subset of data.
question

Select query
answer

A ________ displays a subset of data from a table (or tables) based on the criteria specified.
question

relational algebra
answer

SQL uses ________ to extract records from a database by using English-like expressions that have variables and operations.
question

Join
answer

When you want to extract data from two or more tables, you use a(n) ________ query.
question

Exporting
answer

________ involves putting data into an electronic file in a format that another application can understand.
question

Warehouse
answer

A data ________ is a large-scale electronic repository of data that contains and organizes all of an organization’s data in one place.
question

Data mine
answer

Which of the following is NOT a data source for a data warehouse?
question

Mining of data
answer

Data staging consists of all of the following steps, EXCEPT ________.
question

Office support system
answer

A(n) ________ is designed to improve communications and assist employees in accomplishing their daily tasks.
question

Real time
answer

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

Batch
answer

In a transaction-processing system, if transaction data are accumulated until a certain point and then many transactions are processed all at once, this is called ________ processing.
question

Redundancy
answer

Which of the following is NOT a type of management information system (MIS) report?
question

exception reports
answer

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

natural language processing (NLP) system
answer

The Siri speech-recognition feature on Apple’s iPhone 4s is an example of a ________.
question

Artificial intelligence
answer

________ is the branch of computer science that deals with the attempt to create computers that think like humans.
question

External data
answer

An example of ________ is customer demographic data purchased from third parties or statistics compiled by the federal government.
question

Internal data
answer

In a data warehouse, data gathered from sales, billing, and inventory departments are examples of ________ sources.
question

Knowledge base system
answer

An expert system and a natural language processing system are both _.
question

Data mining
answer

Classification, affinity grouping, and estimation are ________ methods used by managers to make their data more meaningful.

Get instant access to
all materials

Become a Member