WGU D426 DATA MANAGEMENT FOUNDATIONS V1 V2 V3 OA 2025/2026 REAL EXAM QUESTIONS AND ANSWERS VERIFIED FOR GUARANTEED PASS LATEST UPDATE

WGU D426 DATA MANAGEMENT FOUNDATIONS V1 V2
V3 OA 2025/2026 REAL EXAM QUESTIONS AND
ANSWERS VERIFIED FOR GUARANTEED PASS
LATEST UPDATE


Q1. A is a column, or group of columns, used to identify a row.
A. Foreign key
B. Primary key
C. Candidate key
D. Index
Correct Answer: B
Rationale: A primary key uniquely identifies each row in a table and ensures no duplicates.

Q2. A consists of a single column.
A. Composite primary key
B. Simple primary key
C. Surrogate key
D. Foreign key
Correct Answer: B
Rationale: A simple key uses just one column to uniquely identify rows.

Q3. A key consists of multiple columns.
A. Candidate key
B. Composite primary key
C. Surrogate key
D. Unique key
Correct Answer: B
Rationale: A composite key requires more than one column to ensure uniqueness.

Q4. All primary key columns are necessary for uniqueness. If any column is removed,
uniqueness is lost. This property is called:
1

,WGU D426 DATA MANAGEMENT FOUNDATIONS V1 V2
V3 OA 2025/2026 REAL EXAM QUESTIONS AND
ANSWERS VERIFIED FOR GUARANTEED PASS
LATEST UPDATE
A. Minimal
B. Composite
C. Candidate
D. Functional
Correct Answer: A
Rationale: Minimality ensures that only the whole set provides uniqueness.

Q5. The constraint in CREATE TABLE names the table’s primary key.
A. Unique
B. Primary key
C. Foreign key
D. Check
Correct Answer: B
Rationale: PRIMARY KEY enforces uniqueness and non-nullability.

Q6. An is a numeric column assigned an automatically incrementing value when a row is
inserted.
A. Surrogate key
B. Auto-increment column
C. Candidate key
D. Artificial key
Correct Answer: B
Rationale: Auto-increment columns generate sequential IDs automatically.

Q7. The keyword defines an auto-increment column.
A. DEFAULT
B. AUTO_INCREMENT
C. UNIQUE
D. SERIAL
Correct Answer: B
Rationale: AUTO_INCREMENT automatically increases numeric values.




2

,WGU D426 DATA MANAGEMENT FOUNDATIONS V1 V2
V3 OA 2025/2026 REAL EXAM QUESTIONS AND
ANSWERS VERIFIED FOR GUARANTEED PASS
LATEST UPDATE
Q8. A is a column, or group of columns, that refers to a primary key.
A. Surrogate key
B. Foreign key
C. Candidate key
D. Index
Correct Answer: B
Rationale: A foreign key enforces relationships between tables.

Q9. requires foreign key values to either be NULL or match some primary key.
A. Referential integrity
B. Entity integrity
C. Normalization
D. Minimality
Correct Answer: A
Rationale: Referential integrity ensures valid references or NULL.

Q10. A constraint uses the and REFERENCES keywords.
A. Primary key; DEFAULT
B. Foreign key; REFERENCES
C. Unique; INDEX
D. Check; VALUE
Correct Answer: B
Rationale: FOREIGN KEY … REFERENCES enforces relationships.

Q11. A foreign key has all NULL columns.
A. Simple
B. Composite
C. Fully NULL
D. Candidate
Correct Answer: C
Rationale: Fully NULL foreign keys represent no relationship.




3

, WGU D426 DATA MANAGEMENT FOUNDATIONS V1 V2
V3 OA 2025/2026 REAL EXAM QUESTIONS AND
ANSWERS VERIFIED FOR GUARANTEED PASS
LATEST UPDATE
Q12. Which action rejects an insert/update/delete that violates referential integrity?
A. CASCADE
B. RESTRICT
C. SET NULL
D. SET DEFAULT
Correct Answer: B
Rationale: RESTRICT blocks any violating change.

Q13. Which action sets invalid foreign keys to NULL?
A. SET NULL
B. CASCADE
C. RESTRICT
D. SET DEFAULT
Correct Answer: A
Rationale: SET NULL clears invalid references.

Q14. Which action sets invalid foreign keys to a default value?
A. SET DEFAULT
B. CASCADE
C. RESTRICT
D. SET NULL
Correct Answer: A
Rationale: SET DEFAULT assigns default when FK is invalid.

Q15. Which action propagates primary key changes to foreign keys?
A. RESTRICT
B. SET NULL
C. SET DEFAULT
D. CASCADE
Correct Answer: D
Rationale: CASCADE ensures dependent rows update accordingly.




4