1
WGU C175/D426 DATA MANAGEMENT
FOUNDATIONS OA EXAM NEWEST 2026 —
ACTUAL EXAM 2 Latest Versions | 300
Questions with Correct Detailed Answers &
Rationales— Already Graded A+
Question 1
What is a broad definition of data?
A) Information processed and organized for decision making
B) Raw facts captured on printed or digital media
C) Knowledge derived from analysis
D) Structured information stored in databases
Correct Answer: B) Raw facts captured on printed or digital media
Rationale: Data is defined as raw facts that have not yet been processed or
organized. These facts are captured on various media (printed or digital) and
serve as the foundation for creating information through processing and
analysis.
A) This describes information, not raw data.
C) This describes knowledge, which is derived from information.
D) This describes structured data but is not a broad definition.
Question 2
What are data?
A) Information that has been analyzed
B) Facts that are collected and stored in a database system
C) Processed information
D) Reports generated from databases
Correct Answer: B) Facts that are collected and stored in a database
system
pg. 1
,2
Rationale: Data are facts that are collected and stored in a database system.
These facts are unprocessed and serve as the raw material for generating
information and knowledge through database operations.
A) Analyzed facts become information, not raw data.
C) Processed information is a higher-level concept.
D) Reports are outputs, not raw data.
Question 3
What is a determining characteristic of unstructured data?
A) It follows a strict relational model
B) It does not follow a data model
C) It is stored in tables
D) It has a predefined schema
Correct Answer: B) It does not follow a data model
Rationale: Unstructured data does not follow a specific data model or
structure. Examples include text documents, images, audio files, and videos.
Unlike structured data, it cannot be easily stored in traditional relational
databases.
A) Unstructured data does NOT follow a strict relational model.
C) Unstructured data is not stored in tables.
D) Unstructured data has no predefined schema.
Question 4
What is true about flat files?
A) They contain hierarchical organization
B) They contain no internal hierarchical organization
C) They are relational databases
D) They have complex relationships
Correct Answer: B) They contain no internal hierarchical organization
pg. 2
,3
Rationale: Flat files are simple files that contain records with no internal
hierarchical organization or relationships between files. They lack the
structural complexity of relational databases.
A) Flat files have NO hierarchical organization.
C) Flat files are NOT relational databases.
D) Flat files have no complex relationships.
Question 5
How were data retrieved before database management systems?
A) Through complex queries
B) Sequentially from simple files
C) Through relational algebra
D) Using SQL commands
Correct Answer: B) Sequentially from simple files
Rationale: Before the advent of Database Management Systems (DBMS), data
was stored in simple files and retrieved sequentially. This approach was
inefficient and required programs to navigate through files to find specific
records.
A) Complex queries require a DBMS.
C) Relational algebra is used with relational databases.
D) SQL requires a DBMS.
Question 6
What does modality refer to, and how does it appear on an ER diagram?
A) The maximum number of times an instance can be associated; appears as a
0 or 1
B) The minimum number of times an instance can be associated; appears
as a 0 or 1
C) The average number of associations; appears as a 0 or 1
D) The total number of associations; appears as a number
pg. 3
, 4
Correct Answer: B) The minimum number of times an instance can be
associated; appears as a 0 or 1
Rationale: Modality in an ER diagram represents the minimum number of
times an instance in one entity can be associated with an instance in another
entity. It appears as a 0 or 1 next to cardinality on the relationship line,
indicating whether participation is optional (0) or mandatory (1).
A) Cardinality refers to the maximum, not modality.
C) Modality is not about the average.
D) Modality appears as 0 or 1, not as a general number.
Question 7
Define referential integrity.
A) Requires that all foreign key values must either be fully NULL or
match some primary key value
B) Requires that all primary key values must be unique
C) Requires that all foreign key values must be NULL
D) Requires that all primary key values must match foreign key values
Correct Answer: A) Requires that all foreign key values must either be
fully NULL or match some primary key value
Rationale: Referential integrity is a database constraint that ensures
relationships between tables remain consistent. It requires that every foreign
key value in a table either matches a primary key value in the referenced table
or is entirely NULL.
B) This describes entity integrity, not referential integrity.
C) Foreign keys can be non-NULL if they match a primary key.
D) Primary keys need not match all foreign key values.
Question 8
Which of the following is NOT a way referential integrity can be violated?
A) Primary key is updated
B) Row containing primary key is deleted
pg. 4
WGU C175/D426 DATA MANAGEMENT
FOUNDATIONS OA EXAM NEWEST 2026 —
ACTUAL EXAM 2 Latest Versions | 300
Questions with Correct Detailed Answers &
Rationales— Already Graded A+
Question 1
What is a broad definition of data?
A) Information processed and organized for decision making
B) Raw facts captured on printed or digital media
C) Knowledge derived from analysis
D) Structured information stored in databases
Correct Answer: B) Raw facts captured on printed or digital media
Rationale: Data is defined as raw facts that have not yet been processed or
organized. These facts are captured on various media (printed or digital) and
serve as the foundation for creating information through processing and
analysis.
A) This describes information, not raw data.
C) This describes knowledge, which is derived from information.
D) This describes structured data but is not a broad definition.
Question 2
What are data?
A) Information that has been analyzed
B) Facts that are collected and stored in a database system
C) Processed information
D) Reports generated from databases
Correct Answer: B) Facts that are collected and stored in a database
system
pg. 1
,2
Rationale: Data are facts that are collected and stored in a database system.
These facts are unprocessed and serve as the raw material for generating
information and knowledge through database operations.
A) Analyzed facts become information, not raw data.
C) Processed information is a higher-level concept.
D) Reports are outputs, not raw data.
Question 3
What is a determining characteristic of unstructured data?
A) It follows a strict relational model
B) It does not follow a data model
C) It is stored in tables
D) It has a predefined schema
Correct Answer: B) It does not follow a data model
Rationale: Unstructured data does not follow a specific data model or
structure. Examples include text documents, images, audio files, and videos.
Unlike structured data, it cannot be easily stored in traditional relational
databases.
A) Unstructured data does NOT follow a strict relational model.
C) Unstructured data is not stored in tables.
D) Unstructured data has no predefined schema.
Question 4
What is true about flat files?
A) They contain hierarchical organization
B) They contain no internal hierarchical organization
C) They are relational databases
D) They have complex relationships
Correct Answer: B) They contain no internal hierarchical organization
pg. 2
,3
Rationale: Flat files are simple files that contain records with no internal
hierarchical organization or relationships between files. They lack the
structural complexity of relational databases.
A) Flat files have NO hierarchical organization.
C) Flat files are NOT relational databases.
D) Flat files have no complex relationships.
Question 5
How were data retrieved before database management systems?
A) Through complex queries
B) Sequentially from simple files
C) Through relational algebra
D) Using SQL commands
Correct Answer: B) Sequentially from simple files
Rationale: Before the advent of Database Management Systems (DBMS), data
was stored in simple files and retrieved sequentially. This approach was
inefficient and required programs to navigate through files to find specific
records.
A) Complex queries require a DBMS.
C) Relational algebra is used with relational databases.
D) SQL requires a DBMS.
Question 6
What does modality refer to, and how does it appear on an ER diagram?
A) The maximum number of times an instance can be associated; appears as a
0 or 1
B) The minimum number of times an instance can be associated; appears
as a 0 or 1
C) The average number of associations; appears as a 0 or 1
D) The total number of associations; appears as a number
pg. 3
, 4
Correct Answer: B) The minimum number of times an instance can be
associated; appears as a 0 or 1
Rationale: Modality in an ER diagram represents the minimum number of
times an instance in one entity can be associated with an instance in another
entity. It appears as a 0 or 1 next to cardinality on the relationship line,
indicating whether participation is optional (0) or mandatory (1).
A) Cardinality refers to the maximum, not modality.
C) Modality is not about the average.
D) Modality appears as 0 or 1, not as a general number.
Question 7
Define referential integrity.
A) Requires that all foreign key values must either be fully NULL or
match some primary key value
B) Requires that all primary key values must be unique
C) Requires that all foreign key values must be NULL
D) Requires that all primary key values must match foreign key values
Correct Answer: A) Requires that all foreign key values must either be
fully NULL or match some primary key value
Rationale: Referential integrity is a database constraint that ensures
relationships between tables remain consistent. It requires that every foreign
key value in a table either matches a primary key value in the referenced table
or is entirely NULL.
B) This describes entity integrity, not referential integrity.
C) Foreign keys can be non-NULL if they match a primary key.
D) Primary keys need not match all foreign key values.
Question 8
Which of the following is NOT a way referential integrity can be violated?
A) Primary key is updated
B) Row containing primary key is deleted
pg. 4
