WGU D427 DATABASE MANAGEMENT
APPLICATIONS CERTIFICATION EVALUATION
TEST PAPER WITH SOLUTIONS
◉ 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.
◉ Online analytical processing (OLAP).
Answer: Decision support system (DSS) tools that use
multidimensional data analysis techniques. OLAP creates an
advanced data analysis environment that supports decision making,
business modeling, and operations research.
◉ Operational database.
Answer: A database designed to primarily support a company's day-
to-day operations. Also known as a transactional database, OLTP
database, or production database.
◉ Record.
Answer: A collection of related (logically connected) fields.
, ◉ Semistructured data.
Answer: Data that has already been processed to some extent.
◉ Structural dependence.
Answer: A data characteristic in which a change in the database
schema affects data access, thus requiring changes in all access
programs.
◉ Structural independence.
Answer: A data characteristic in which changes in the database
schema do not affect data access.
◉ Structured data.
Answer: Data that has been formatted to facilitate storage, use, and
information generation.
◉ Unstructured data.
Answer: Data that exists in its original, raw state; that is, in the
format in which it was collected.
◉ Workgroup database.
APPLICATIONS CERTIFICATION EVALUATION
TEST PAPER WITH SOLUTIONS
◉ 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.
◉ Online analytical processing (OLAP).
Answer: Decision support system (DSS) tools that use
multidimensional data analysis techniques. OLAP creates an
advanced data analysis environment that supports decision making,
business modeling, and operations research.
◉ Operational database.
Answer: A database designed to primarily support a company's day-
to-day operations. Also known as a transactional database, OLTP
database, or production database.
◉ Record.
Answer: A collection of related (logically connected) fields.
, ◉ Semistructured data.
Answer: Data that has already been processed to some extent.
◉ Structural dependence.
Answer: A data characteristic in which a change in the database
schema affects data access, thus requiring changes in all access
programs.
◉ Structural independence.
Answer: A data characteristic in which changes in the database
schema do not affect data access.
◉ Structured data.
Answer: Data that has been formatted to facilitate storage, use, and
information generation.
◉ Unstructured data.
Answer: Data that exists in its original, raw state; that is, in the
format in which it was collected.
◉ Workgroup database.
