question

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

answer

Database

question

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 ________.

answer

Redundancy

question

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

answer

Integrity

question

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

answer

Data centralization

question

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

answer

Database information cannot be changed once it is entered.

question

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

answer

Administrator

question

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

answer

Implementing data mining

question

What does the acronym DBMS stand for?

answer

Data management system

question

Microsoft ________ is a database management system.

answer

Access

question

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

answer

Field

question

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

answer

Record

question

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

answer

Table

question

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

answer

Numeric

question

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

answer

Object

question

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

answer

Hyperlink

question

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

answer

99999

question

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

answer

Data dictionary

question

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

answer

Dictionary

question

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

answer

Field

question

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

answer

Default value

question

Which of the following is NOT a likely primary key?

answer

Street address

question

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

answer

Normalization

question

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

answer

Primary key

question

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

answer

Relational

question

In a relational database, what is a relationship?

answer

A link between tables that defines how the data are related

question

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

answer

One-to-one

question

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

answer

Referential integrity

question

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

answer

Unstructured

question

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

answer

binary large objects (BLOBs

question

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

answer

They store data in table format

question

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

answer

Cube

question

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

answer

Range

question

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

answer

Completeness

question

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

answer

Consistency

question

A ________ temporarily displays records that match the specified criteria.

answer

Filter

question

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

answer

Query

question

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

answer

Select query

question

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

answer

relational algebra

question

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

answer

Join

question

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

answer

Exporting

question

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

answer

Warehouse

question

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

answer

Data mine

question

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

answer

Mining of data

question

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

answer

Office support system

question

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

answer

Real time

question

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.

answer

Batch

question

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

answer

Redundancy

question

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

answer

exception reports

question

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

answer

natural language processing (NLP) system

question

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

answer

Artificial intelligence

question

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

answer

External data

question

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

answer

Internal data

question

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

answer

Knowledge base system

question

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

answer

Data mining

Chapter 11 (notes 1) – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards