Database

Database

The Database Environment has 30 Questions

A data warehouse uses:

partial operational data.
historical operational data.
future operational data.
health care data.
All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.

True
False
Metadata enables database designers and users to do all of the following except:

sample data.
understand what data exist.
what the fine distinctions are between similar data items.
what the data mean.
Database management systems were first introduced in the 1950s.

True
False
Duplicate data often results in loss of data integrity because:

the data formats may be inconsistent.
data values may not agree.
Both A & B.
Neither A & B.
Databases that contain historical and summarized information are usually called data warehouses.

True
False
Legacy data is which of the following?

Data contained in a newly-installed system
Data rejected during the installation of a new system
Data contained in a file system
Data contained by a system used prior to the installation of a new system
An advantage of the database approach is the creation of maximum data redundancy.

True
False
A database management system (DBMS) is a:

hardware system used to create, maintain, and provide controlled access to a database.
hardware system used to create, maintain, and provide uncontrolled access to a database.
software system used to create, maintain, and provide controlled access to a database.
software system used to create, maintain, and provide uncontrolled access to a database.
An enterprise data model is a relational model that shows the high-level entities for the organization and associations among those entities.

True
False
A database application can perform which of the following activities?

Add records
Read records
Update records
All of the above.
A workgroup typically comprises between 25 and 100 persons.

True
False
An enterprise data model is:

a graphical model that shows the high-level entities for an organization.
a graphical model that shows all entities for an organization.
a non-graphical model that shows the high-level entities for an organization.
a non-graphical model that shows the all entities for an organization.
The source of the data is sometimes called the system of record.

True
False
A shared database should:

be accurate and available.
provide for backup and recovery.
be secure.
All of the above.
Data quality problems currently cost U.S. businesses some $60 million each year (Hudica, 2003).

True
False
Data administrators are responsible for:

physical database design.
managing technical issues in the database environment.
overall management of data resources in an organization.
writing application programs.
Stand-alone databases exhibit many of the same advantages common to file processing systems.

True
False
Which of the following types of databases are the most common?

Personal
Workgroup
Department
Enterprise
The database approach requires additional costs and risks.

True
False
Which of the following is true for a relational database?

Data is represented by tables.
It is difficult to access data.
Complex programs have to be written for simple queries.
All of the above.
Data descriptions are stored in a central location called the depository.

True
False
Some advantages of the database approach include all, but:

minimal data redundancy.
improved data consistency.
improved data sharing.
program-data dependency.
Stored representations of objects and events that have meaning and importance in the user's environment are known as a database.

True
False
An enterprise database is which of the following?

A database designed to support only users external to an organization
A database designed to support an entire organization
A database designed to support a relatively small group
A database designed to support a single PC
Another name for multimedia data is unstructured data.

True
False
Structured data may include which of the following?

Photo image
Video clip
Dates
None of the above.
The most common source of database failures in an organization is the failure to implement a strong database administration function.

True
False
An extranet is which of the following?

The use of Internet protocols with limited access to company data by the company's customers and suppliers.
The use of Internet protocols with unlimited access to company data by the company's customers and suppliers.
The use of Internet protocols with limited access to company data by people within an organization.
The use of Internet protocols with unlimited access to company data by people within an organization.
The primary mechanism for providing context for data is metadata.

True
False