INSY 3304 CH 1

________ database focuses primarily on storing historical data and business metrics used exclusively for tactical or strategic decision making.

Analytical

A data ________ develops when all of the required changes in the redundant data are not made successfully.

Anomaly

A database that supports data located at a single site is called a ________ database.

Centralized

John is working in the customer table and needs to know what customers are located in Florida. To find the information he would ________.

Create a new query

The ________ manages interaction between the end user and the database.

DBMS

The ________ receives all application requests and translates them into the complex operations required to fulfill requests.

DBMS

Because all data access programs are subject to change when any of a file's data storage characteristics change (that is, changing the data type), a file system is said to exhibit ________.

Data dependence

________ are considered database architects.

Data designers

Which of the following DBMS functions relieves users from defining and programming the physical data characteristics?

Data storage management

The ________ is a specialized database that stores data in a format optimized for decision support.

Data warehouse

The term ________ system refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.

Database

________ refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data.

Database Design

________ are the people who use application programs to run the organization's daily operations.

End Users

Where does the DBMS store the definitions of data elements and their relationships?

In a data dictionary

Data ________ exists when it is possible to make changes in the data storage characteristics without affecting the application program's ability to access the data.

Independence

The results obtained from using wind speed and atmospheric pressure to predict weather can be termed as ________.

Information

________, which is processed data, can be used as the foundation for decision making.

Information

Data ________ is defined as "the condition in which all of the data in the database are consistent with the real-world events and conditions."

Integrity

Which of the following is true of Knowledge?

It has its bedrock in information

The human being views data in a ________ format.

Logical

Which of the following products do not provide an enterprise database?

MS Access

What is the name for data about data?

Metadata

An example of a general-purpose database would be ________.

ProQuest databases that contain newspaper articles for a variety of topics

________ are the instructions and rules that govern the design and use of the database system.

Procedures

________ is the key to good decision making.

Production of accurate, relevant, and timely information

What is the name for an answer to a query that the DBMS sends back to the application?

Query result set

Data refer to:

Raw facts

________ deals with fixing the database after a failure such as a disk or power failure.

Recovery

Database management systems, operating systems, applications and utilities are all examples of ________.

Software

________ is the de facto query language and data access standard supported by the majority of DBMS vendors.

Structured Query Language

Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ________.

Tuning

A raw fact such as a telephone number is known as ________.

data

The design of a ________ database recognizes the use of historical and aggregated data.

data warehouse

A single-user database that runs on a personal computer is called a(n) ________ database.

desktop

What is a benefit of using a DBMS?

it helps create an environment for end users to have access to more data

A(n) ________ allows the user to specify what must be done without specifying how it must be done.

nonprocedural language

The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ________.

query language

A ________ is a logically connected set of one or more fields.

record

All fields for a specific entity can be grouped together as a ________.

record

Data processing (DP) specialists are in existence because of ________.

the need to track data and produce required reports

A ________ database supports a relatively small number of users or a specific department within the organization.

workgroup