CHAP 11

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

default value

______ involves putting data into an electronic file in a format that another application can understand

exporting

An example of ______ is customer demographic data purchased from third parties or statistics complied by the federal government.

external data

A ______ temporarily displays records that much the specified criteria.

filter

A web address is stored as a(n) ______ field in a database.

hyperlink

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

implementing data mining

In a data warehouse, data gathered from sales, billing, and inventory department are examples of ______ sources.

internal data

An expert system and a natural language processing system are both ______.

knowledge-based systems

Data staging consists of all of the following steps, EXCEPT ______.

mining of data

The Siri speech-recognition feature on Apple's iPhone 4s is an example of a ______.

natural language processing (NLP) system

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

numeric

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

object

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

one-to-one

A(n) ______ is a way of retrieving information from one or more tables that defines a particular subset of data

query

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

range

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

redundancy

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

redundancy

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

relational algebra

In a relational database, what is a relationship

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

Microsoft ______ is a database management system.

Access

Unstructured data such as vide clips, and pictures are known as ______ because of the way they are encoded.

Binary large Objects (BLOBs)

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

Type

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

database information cannot be changed one it is entered.

A database schema is also called a(n) ______.

data dictionary

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

data mine

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

data mining

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

99999

What does the acronym DBMS stand for?

Database management system

______ means that or each value in the foreign key of one table, there is a corresponding value in the primary key of another table

Referential integrity

Which of the following statements about object oriented database is FALSE?

They store data in table format

An individual trained in the design and building of database is called a database ______.

administrator

Data in a multidimensional database is organized in a ______ format.

cube

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

unstructured