Chapter 1 Flashcards
Data and information are essentially the same thing.
False
Data processing can be as simple as organizing data to reveal patterns.
True
Data constitute the building blocks of information.
True
Metadata present a more complete picture of the data in the database than the data itself.
True
The DBMS reveals much of the database’s internal complexity to the application programs and users.
False
One disadvantage of the DBMS is that it increases the risk of data security breaches.
False
The same data might be simultaneously structured and unstructured depending on the intended processing.
True
Corporations use only structured data.
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
A query language is a procedural language.
False
____ is used to reveal the meaning of data.
Information
Accurate, relevant, and timely information is the key to ____.
Good decision making
____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database.
Metadata
The ____ serve(s) as the intermediary between the user and the database.
DBMS
____ exists when different versions of the same data appear in different places.
Data inconsistency
The response of the DBMS to a query is the ____.
Query result set
A(n) ____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.
Workgroup
A ____ database supports data distributed across several different sites.
Distributed
Most decision-support data are based on historical data obtained from ____.
Operational databases
____ is a set of tools that work together to provide an advanced data analysis environment for retrieving, processing, and modeling data from the data warehouse.
Online analytical processing
____ data are the result of formatting to facilitate storage, use and generation of information.
Structured
Most data you encounter is best classified as ____.
Semi-structured
The organization of the data within the folders in a manual file system was determined by ____.
Expected use
A ____ is a logically connected set of one or more fields that describes a person, place, or thing.
Record
The phrase ____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.
Database system
____ relates to the activities that make the database perform more efficiently in terms of storage and access speed.
Performance tuning
We are now said to be entering the “knowledge age.”
True
The only way to access the data in a database is through the DBMS.
True
An operational database is sometimes referred to as an enterprise database.
False
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
____ is the body of information and facts about a specific subject.
Knowledge
The database structure in a DBMS is stored as a ____.
Collection of files
A(n) ____ database is designed to support a company’s day-to-day operations.
Transactional
A workgroup database is a(n)____ database.
Multiuser
____ data exist in the format in which they were collected.
Unstructured
Which of the following is an example of structured data?
Email, web page, memo, or *spreadsheet?
A ____ is a collection of related records.
File