Foundations_2026 Exam
Flashcards
2026_2027 UPDATES
Questions And Answers
Solved 100% Correct
_Certified Study Resources
, Ad hoc query A spur-of-the-moment question.
Analytical database A database focused primarily on storing historical data and business metrics used
for tactical or strategic decision making.
Centralized database A database located at a single site.
Cloud database A database that is created and maintained using cloud services, such as Azure or
AWS.
Data Raw facts, or facts that have not yet been processed to reveal their meaning to the
end user.
Data anomaly 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 A data condition in which data representation and manipulation are dependent on
the physical data storage characteristics.
Data dictionary 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 A condition in which different versions of the same data yield different results.
Data independence A condition in which data access is unaffected by changes in the physical data
storage characteristics.
Data integrity In a relational database, a condition in which data in the database compiles with all
entity and referential integrity constraints.
Data management A process that focuses on data collection, storage, and retrieval. Common data
management functions include addition, deletion, modification, and listing.
Database system An organization of components that defines and regulates the collection, storage,
management, and use of data in a database environment.
Desktop database A single-user database that runs on a personal computer.
Field 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.