WGU C175/D426 DATA MANAGEMENT FOUNDATIONS
OA EXAM WITH REAL QUESTIONS AND WELL VERIFIED
ANSWERS |GUARANTEED PASS
How do entity and attribute maxima appear in an ER diagram? - CORRECT
ANSWER ✔✔- As M or 1 following the attribute name
What combination of entity and attribute maxima/minima is considered unique? -
CORRECT ANSWER ✔✔- If the first number is a 1
What combination of entity and attribute maxima/minima is considered singular?
- CORRECT ANSWER ✔✔- If the second number is 1
What combination of entity and attribute maxima/minima is considered plural? -
CORRECT ANSWER ✔✔- If the second number is M
Define: Select Operation - CORRECT ANSWER ✔✔- Selects table rows based in
logical expression (σ)
Define: Project Operation - CORRECT ANSWER ✔✔- Selects Table Columns (II)
Define: Join Operation - CORRECT ANSWER ✔✔- Joins two tables (⋈)
Define: Union operation - CORRECT ANSWER ✔✔- Combines ALL rows of two
compatible tables into a single table (U)
1|Page
, Define: Intersect Operation (and how it appears on an ER diagram) - CORRECT
ANSWER ✔✔- Operates on two compatible tables and returns only rows that
appear in BOTh tables (∩)
Appears as a line and square coming off of a relationship between two other
entities
What does cardinality refer to? How does it appear on ER diagram? - CORRECT
ANSWER ✔✔- Refers to the MAXIMUM number of times an instance in one entity
can be associated with instance of another entity (Maxima)
Appears as a 1 or M on the relationship line, closest to entity
What does modality refer to? How does it appear on ER diagram? - CORRECT
ANSWER ✔✔- Refers to the MINIMUM number of times an instance in one entity
can be associated with instance of another entity (minima)
Appears as a 0 or 1 on the relationship line, next to cardinality
Define: Referential Integrity - CORRECT ANSWER ✔✔- Requires that ALL foreign
key values must either be fully NULL or match some primary key value
4 Ways Referential Integrity can be violated: - CORRECT ANSWER ✔✔- 1. Primary
key is updated
2. Foreign key is updated
3. Row containing primary key is DELETED
4. Row containing foreign key is INSERTED
4 Actions to Correct Referential Integrity Violation: - CORRECT ANSWER ✔✔- 1.
RESTRICT - rejects an insert, update, or delete
2|Page
OA EXAM WITH REAL QUESTIONS AND WELL VERIFIED
ANSWERS |GUARANTEED PASS
How do entity and attribute maxima appear in an ER diagram? - CORRECT
ANSWER ✔✔- As M or 1 following the attribute name
What combination of entity and attribute maxima/minima is considered unique? -
CORRECT ANSWER ✔✔- If the first number is a 1
What combination of entity and attribute maxima/minima is considered singular?
- CORRECT ANSWER ✔✔- If the second number is 1
What combination of entity and attribute maxima/minima is considered plural? -
CORRECT ANSWER ✔✔- If the second number is M
Define: Select Operation - CORRECT ANSWER ✔✔- Selects table rows based in
logical expression (σ)
Define: Project Operation - CORRECT ANSWER ✔✔- Selects Table Columns (II)
Define: Join Operation - CORRECT ANSWER ✔✔- Joins two tables (⋈)
Define: Union operation - CORRECT ANSWER ✔✔- Combines ALL rows of two
compatible tables into a single table (U)
1|Page
, Define: Intersect Operation (and how it appears on an ER diagram) - CORRECT
ANSWER ✔✔- Operates on two compatible tables and returns only rows that
appear in BOTh tables (∩)
Appears as a line and square coming off of a relationship between two other
entities
What does cardinality refer to? How does it appear on ER diagram? - CORRECT
ANSWER ✔✔- Refers to the MAXIMUM number of times an instance in one entity
can be associated with instance of another entity (Maxima)
Appears as a 1 or M on the relationship line, closest to entity
What does modality refer to? How does it appear on ER diagram? - CORRECT
ANSWER ✔✔- Refers to the MINIMUM number of times an instance in one entity
can be associated with instance of another entity (minima)
Appears as a 0 or 1 on the relationship line, next to cardinality
Define: Referential Integrity - CORRECT ANSWER ✔✔- Requires that ALL foreign
key values must either be fully NULL or match some primary key value
4 Ways Referential Integrity can be violated: - CORRECT ANSWER ✔✔- 1. Primary
key is updated
2. Foreign key is updated
3. Row containing primary key is DELETED
4. Row containing foreign key is INSERTED
4 Actions to Correct Referential Integrity Violation: - CORRECT ANSWER ✔✔- 1.
RESTRICT - rejects an insert, update, or delete
2|Page
