WGU C175 - CHAPTER 1: INTRO TO DATABASES,
INFORMATION, AND DATA STUDY GUIDE
Ad Hoc Query - Answers - A spur-of-the moment question
Analytical Database - Answers - A database focused primarily on storing historical data
and business metrics used for tactical or strategic decision making
Availability - Answers - The accessibility of data whenever required by authorized users
and for authorized purposes
Cloud Database - Answers - A database that is created and maintained using cloud
services, such as Microsoft Azure or Amazon AWS
Data - Answers - Raw facts, or facts that have not yet been processed to reveal their
meaning to the end user
Data Anomaly - Answers - A data abnormality in which inconsistent changes have been
made to a database.
Data Dependence - Answers - A data condition in which data representation and
manipulation are dependent on the physical data storage characteristics
Data Dictionary - Answers - A DBMS component that stores metadata - data about
data. May also include data that are external to the DBMS.
Data Inconsistency - Answers - A condition in which different versions of the same data
yield different (inconsistent) results
Data Independence - Answers - A condition in which data access is unaffected by
changes in the physical data storage characteristics
Data Integrity - Answers - In a relational database, a condition in which the data in the
database complies with all entity and referential integrity constraints
Data Management - Answers - A process that focuses on data collection, storage, and
retrieval. Common data management functions include addition, deletion, modification,
and listing
Data Processing (DP) Specialist - Answers - The person responsible for developing and
managing a computerized file processing system
INFORMATION, AND DATA STUDY GUIDE
Ad Hoc Query - Answers - A spur-of-the moment question
Analytical Database - Answers - A database focused primarily on storing historical data
and business metrics used for tactical or strategic decision making
Availability - Answers - The accessibility of data whenever required by authorized users
and for authorized purposes
Cloud Database - Answers - A database that is created and maintained using cloud
services, such as Microsoft Azure or Amazon AWS
Data - Answers - Raw facts, or facts that have not yet been processed to reveal their
meaning to the end user
Data Anomaly - Answers - A data abnormality in which inconsistent changes have been
made to a database.
Data Dependence - Answers - A data condition in which data representation and
manipulation are dependent on the physical data storage characteristics
Data Dictionary - Answers - A DBMS component that stores metadata - data about
data. May also include data that are external to the DBMS.
Data Inconsistency - Answers - A condition in which different versions of the same data
yield different (inconsistent) results
Data Independence - Answers - A condition in which data access is unaffected by
changes in the physical data storage characteristics
Data Integrity - Answers - In a relational database, a condition in which the data in the
database complies with all entity and referential integrity constraints
Data Management - Answers - A process that focuses on data collection, storage, and
retrieval. Common data management functions include addition, deletion, modification,
and listing
Data Processing (DP) Specialist - Answers - The person responsible for developing and
managing a computerized file processing system
