Management Foundations Test Guide
2026 Updated
Ad hoc query -- Verified--Solution----A spur-of-the-moment question.
Analytical database -- Verified--Solution----A database focused
primarily on storing historical data and business metrics used for tactical
or strategic decision making.
Centralized database -- Verified--Solution----A database located at a
single site.
Cloud database -- Verified--Solution----A database that is created and
maintained using cloud services, such as Azure or AWS.
Data -- Verified--Solution----Raw facts, or facts that have not yet been
processed to reveal their meaning to the end user.
Data anomaly -- Verified--Solution----A data abnormality in which
inconsistent changes have been made to a database. For example, an
employee moves, but the address change is not corrected in all files in
the database.
,Data dependence -- Verified--Solution----A data condition in which data
representation and manipulation are dependent on the physical data
storage characteristics.
Data dictionary -- Verified--Solution----A DBMS component that stores
metadata - data about data. Thus, the data dictionary contains the data
definition as well as their characteristics and relationships. A data
dictionary may also include data that are external to the DBMS. Also
known as an information resource dictionary.
Data inconsistency -- Verified--Solution----A condition in which
different versions of the same data yield different results.
Data independence -- Verified--Solution----A condition in which data
access is unaffected by changes in the physical data storage
characteristics.
Data integrity -- Verified--Solution----In a relational database, a
condition in which data in the database compiles with all entity and
referential integrity constraints.
Data management -- Verified--Solution----A process that focuses on data
collection, storage, and retrieval. Common data management functions
include addition, deletion, modification, and listing.
, Database system -- Verified--Solution----An organization of components
that defines and regulates the collection, storage, management, and use
of data in a database environment.
Desktop database -- Verified--Solution----A single-user database that
runs on a personal computer.
Field -- Verified--Solution----An alphabetic or numeric character or
group of characters that defines a characteristic of a person, place, or
thing. For example, a person's Social Security number, address, phone
number, and bank balance are all constitute fields.
File -- Verified--Solution----A named collection of related records.
General-purpose databases -- Verified--Solution----A database that
contains a wide variety of data used in multiple disciplines.
Hub -- Verified--Solution----A warehouse of data packets housed in a
central location on a local area network. It contains multiple ports that
copy the data in the data packets to make it accessible to selected or all
segments of the network.
Information -- Verified--Solution----The result of processing raw data to
reveal its meaning. Information consists of transformed data and
facilitates decision making.