WGU D427 DATABASE MANAGEMENT
APPLICATIONS EXAM UPDATED ACTUAL
QUESTIONS AND CORRECT ANSWERS
◉ 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 understanding of
information as it applies to an environment. A key characteristic is
that new knowledge can be derived from old knowledge.
APPLICATIONS EXAM UPDATED ACTUAL
QUESTIONS AND CORRECT ANSWERS
◉ 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 understanding of
information as it applies to an environment. A key characteristic is
that new knowledge can be derived from old knowledge.
