Ch. 1 Database Systems
____ exists when different versions of the same data appear in different places. A. Data inconsistency B. Data consistency C. Better data integration D. Improved decision making
A. Data inconsistency
____ data are the result of formatting to facilitate storage, use and generation of information. A. Structured B. Semistructured C. Unstructured D. Historical
A. Structured
Most decision-support data are based on historical data obtained from ____. A. operational databases B. data warehouses C. enterprise databases D. workgroup databases
A. operational databases
The database structure in a DBMS is stored as a ____. A. file B. collection of files C. set of key/value pairs D. collection of queries
B. collection of files
The organization of the data within the folders in a manual file system was determined by ____. A. the date of creation B. its expected use C. the title of the documents in the folder D. the data processing specialist
B. its expected use
A workgroup database is a(n)____ database. A. single-user B. multiuser C. enterprise D. distributed
B. multiuser
(T/F) Data and information are essentially the same thing
False
An operational database is sometimes referred to as an enterprise database.
False
Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data
False
The DBMS reveals much of the database's internal complexity to the application programs and users.
False
Data constitute the building blocks of information.
True
Historically, a manual file system was composed of a system of file folders and filing cabinets.
True
One disadvantage of a database system over previous data management approaches is increased costs.
True
We are now said to be entering the "knowledge age."
True
A(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization. A. desktop B. workgroup C. enterprise D. transactional
B. workgroup
____ is the body of information and facts about a specific subject. A. Data B. Information C. Knowledge D. A database
C. Knowledge
____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database. A. Queries B. End-user data C. Metadata D. Information
C. Metadata
____ data exist in the format in which they were collected. A. Structured B. Semistructured C. Unstructured D. Historical
C. Unstructured
Which of the following is an example of structured data? Question options: A. A Web page B. An e-mail C. A memo D. A spreadsheet
D. A spreadsheet
____ is used to reveal the meaning of data. A. Raw facts B. Knowledge C. Formatting D. Information
D. Information
The phrase ____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment. A. database management system B. database management C. management system D. database system
D. database system
A ____ is a collection of related records. A. database B. field C. column D. file
D. file
A(n) ____ database is designed to support a company's day-to-day operations. A. desktop B. workgroup C. enterprise D. transactional
D. transactional
The only way to access the data in a database is through the DBMS.
True
The same data might be simultaneously structured and unstructured depending on the intended processing.
True