WGU D192 DATA SYSTEMS
ADMINISTRATION 200 QUESTIONS FINAL
SCRIPT 2026 FULL SOLUTIONS AND
CORRECT 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.
ADMINISTRATION 200 QUESTIONS FINAL
SCRIPT 2026 FULL SOLUTIONS AND
CORRECT 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.
