1|Page
WGU C175 or D426 DATA MANAGEMENT
FOUNDATIONS OA EXAM ACTUAL EXAM 2 2024-2025
WITH 300 QUESTIONS AND ANSWERS (VERIFIED
ANSWERS) ALREADY GRADED A+
How does Cardinality appear on the ER Diagram - ANSWER-Appears as a
1 or M on the relationship line, closest to entity
Refers to the MAXIMUM number of times an instance in one entity can be
associated with instance of another entity - ANSWER-One-To-Many
Database models were developed to _____? - ANSWER-model real-world
events or conditions
The entity integrity rule requires - ANSWER-All primary keys must be
unique
,2|Page
A table is perceived as a ______. - ANSWER-2 dimensional structure
A table can be logically connected to another table by defining a _____. -
ANSWER-common attribute
We can describe a link by observing that ____. - ANSWER-A primary key
of one table appears again as a foreign key in a related table
An attribute (or group of attributes) that uniquely identifies each entity in a
table is called - ANSWER-Superkey
A foreign key must: - ANSWER-Match a primary key in a related table.
,3|Page
The ERD is used to graphically represent the ____ database model. -
ANSWER-Conceptual
A derived attribute _____. - ANSWER-Need not be physically stored within
the database.
A _____ attribute is one that cannot be subdivided. - ANSWER-Atomic
If an entity can exist apart from one or more related entities, it is said to be:
- ANSWER-Existence-Independent
Dependencies based on only a part of a composite key are called: -
ANSWER-Partial-Dependencies
A special operator used to check for similar character strings is: -
ANSWER-LIKE
, 4|Page
UPDATE tablename ***** WHERE conditionlist What command replaces
the *****? - ANSWER-expression = columnname
What does a record consist of? - ANSWER-A set of one or more fields
What function does A DBMS perform that guarantee the integrity and
consistency of the data in the database? - ANSWER-Data integrity, data
storage, and security management
What is data? - ANSWER-Raw Facts
Database models were developed to what? - ANSWER-Model real-world
events or conditions
WGU C175 or D426 DATA MANAGEMENT
FOUNDATIONS OA EXAM ACTUAL EXAM 2 2024-2025
WITH 300 QUESTIONS AND ANSWERS (VERIFIED
ANSWERS) ALREADY GRADED A+
How does Cardinality appear on the ER Diagram - ANSWER-Appears as a
1 or M on the relationship line, closest to entity
Refers to the MAXIMUM number of times an instance in one entity can be
associated with instance of another entity - ANSWER-One-To-Many
Database models were developed to _____? - ANSWER-model real-world
events or conditions
The entity integrity rule requires - ANSWER-All primary keys must be
unique
,2|Page
A table is perceived as a ______. - ANSWER-2 dimensional structure
A table can be logically connected to another table by defining a _____. -
ANSWER-common attribute
We can describe a link by observing that ____. - ANSWER-A primary key
of one table appears again as a foreign key in a related table
An attribute (or group of attributes) that uniquely identifies each entity in a
table is called - ANSWER-Superkey
A foreign key must: - ANSWER-Match a primary key in a related table.
,3|Page
The ERD is used to graphically represent the ____ database model. -
ANSWER-Conceptual
A derived attribute _____. - ANSWER-Need not be physically stored within
the database.
A _____ attribute is one that cannot be subdivided. - ANSWER-Atomic
If an entity can exist apart from one or more related entities, it is said to be:
- ANSWER-Existence-Independent
Dependencies based on only a part of a composite key are called: -
ANSWER-Partial-Dependencies
A special operator used to check for similar character strings is: -
ANSWER-LIKE
, 4|Page
UPDATE tablename ***** WHERE conditionlist What command replaces
the *****? - ANSWER-expression = columnname
What does a record consist of? - ANSWER-A set of one or more fields
What function does A DBMS perform that guarantee the integrity and
consistency of the data in the database? - ANSWER-Data integrity, data
storage, and security management
What is data? - ANSWER-Raw Facts
Database models were developed to what? - ANSWER-Model real-world
events or conditions
