LIS3784: A1 (Part 1)

Data warehouse

A ________ focuses primarily on storing data used to generate information required to make tactical or strategic decisions.

Database

A ________ system is composed of software, hardware, data, procedures and people.

Anomaly

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

Distributed

A database that supports data distributed across several different sites is called a(n) ________ database.

Set of one or more fields

A record consists of a ________.

Desktop

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

Nonprocedural language

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

Information

Accurate, relevant, and timely ________ is the key to good decision making.

Tuning

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

Record

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

spur of the moment question

An ad hoc query is a ________.

Transactional

Another name for a production database is a ________ database.

Data dependence

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

Independece

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.

Redundancy

Data ________ exists when the same data are stored unnecessarily at different places.

The proper generation, storage, and retrieval of data

Data management is a discipline that focuses on ________.

The need to track data and produce required reports

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

Create a new query

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

Information

Processed data, or ________, can be used as the foundation for decision making.

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

DBMS

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

Data warehouse

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

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

What is a benefit of using a DBMS?

query result set

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

Metadata

What is the name for data about data?

Data dictionary

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

MS Access

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

Database designers

________ are considered database architects.

End users

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

Structural

________ independence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.

Structured Query Language

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