WGU D427 DATABASE DESIGN REVIEW
2026 EXAMINATION QUESTIONS AND
ANSWERS GRADED A+
⩥ Analytical database. Answer: A database focused primarily on storing
historical data and business metrics used for tactical or strategic decision
making.
⩥ Centralized database. Answer: A database located at a single site.
⩥ Cloud database. Answer: A database that is created and maintained
using cloud services, such as Azure or AWS.
⩥ Data. Answer: Raw facts, or facts that have not yet been processed to
reveal their meaning to the end user.
⩥ Data anomaly. Answer: 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. Answer: A data condition in which data
representation and manipulation are dependent on the physical data
storage characteristics.
,⩥ Data dictionary. Answer: 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. Answer: A condition in which different versions
of the same data yield different results.
⩥ Data independence. Answer: A condition in which data access is
unaffected by changes in the physical data storage characteristics.
⩥ Data integrity. Answer: In a relational database, a condition in which
data in the database compiles with all entity and referential integrity
constraints.
⩥ Data management. Answer: A process that focuses on data collection,
storage, and retrieval. Common data management functions include
addition, deletion, modification, and listing.
⩥ Database system. Answer: An organization of components that defines
and regulates the collection, storage, management, and use of data in a
database environment.
, ⩥ Desktop database. Answer: A single-user database that runs on a
personal computer.
⩥ Field. Answer: 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. Answer: A named collection of related records.
⩥ General-purpose databases. Answer: A database that contains a wide
variety of data used in multiple disciplines.
⩥ Hub. Answer: 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. Answer: The result of processing raw data to reveal its
meaning. Information consists of transformed data and facilitates
decision making.
⩥ Knowledge. Answer: The body of information and facts about a
specific subject. Knowledge implies familiarity, awareness, and
2026 EXAMINATION QUESTIONS AND
ANSWERS GRADED A+
⩥ Analytical database. Answer: A database focused primarily on storing
historical data and business metrics used for tactical or strategic decision
making.
⩥ Centralized database. Answer: A database located at a single site.
⩥ Cloud database. Answer: A database that is created and maintained
using cloud services, such as Azure or AWS.
⩥ Data. Answer: Raw facts, or facts that have not yet been processed to
reveal their meaning to the end user.
⩥ Data anomaly. Answer: 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. Answer: A data condition in which data
representation and manipulation are dependent on the physical data
storage characteristics.
,⩥ Data dictionary. Answer: 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. Answer: A condition in which different versions
of the same data yield different results.
⩥ Data independence. Answer: A condition in which data access is
unaffected by changes in the physical data storage characteristics.
⩥ Data integrity. Answer: In a relational database, a condition in which
data in the database compiles with all entity and referential integrity
constraints.
⩥ Data management. Answer: A process that focuses on data collection,
storage, and retrieval. Common data management functions include
addition, deletion, modification, and listing.
⩥ Database system. Answer: An organization of components that defines
and regulates the collection, storage, management, and use of data in a
database environment.
, ⩥ Desktop database. Answer: A single-user database that runs on a
personal computer.
⩥ Field. Answer: 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. Answer: A named collection of related records.
⩥ General-purpose databases. Answer: A database that contains a wide
variety of data used in multiple disciplines.
⩥ Hub. Answer: 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. Answer: The result of processing raw data to reveal its
meaning. Information consists of transformed data and facilitates
decision making.
⩥ Knowledge. Answer: The body of information and facts about a
specific subject. Knowledge implies familiarity, awareness, and
