WGU C175 / D426 Data Management
Foundations OA Exam Actual Exam 2 Latest Versions | 300
Questions & Detailed Answers | 2026 Updated Objective
Assessment Study Guide | DBMS, SQL, ERD, Normalization,
Data Warehousing
THIS EXAM INCLUDE:
• Database Management Systems (DBMS)
• Relational Database Concepts
• SQL Fundamentals
• Data Modeling
• Detailed Answer
• GradedA+
• New Update 2026
, WGU C175 / D426 Data Management Foundations OA Exam
Actual Exam 2 Latest Versions | 300+ Questions & Detailed
Answers | 2026 Updated Objective Assessment Study Guide
| DBMS, SQL, ERD, Normalization, Data Warehousing
1. What does modality refer to in an ER diagram?
A) The maximum number of times an instance can be
associated
B) The minimum number of times an instance can be
associated
C) The total number of entities in a relationship
D) The number of attributes in an entity
Answer: B
2. What does Referential Integrity require?
A) All primary keys must be unique
B) All foreign key values must either be fully NULL or match
some primary key value
C) All tables must be in 3NF
D) No duplicate rows are allowed in any table
Answer: B
3. Which of the following is NOT a way Referential Integrity can
be violated?
, A) Primary key is updated
B) Foreign key is updated
C) Row containing primary key is INSERTED
D) Row containing foreign key is INSERTED
Answer: C
4. Which action to correct Referential Integrity violation sets
invalid foreign keys to null?
A) RESTRICT
B) SET NULL
C) SET DEFAULT
D) CASCADE
Answer: B
5. What is the important aspect of Referential Integrity?
A) Data is stored in a single location
B) Reference to data in one relation is based on values in
another relation
C) All tables must have a foreign key
D) Data must be normalized to 3NF
Answer: B
6. What is the broad definition of data?
A) Processed information stored in databases
B) Raw facts captured on printed or digital media
, C) Organized collections of related records
D) Metadata about database structures
Answer: B
7. What are data in a database system?
A) Processed information
B) Facts that are collected and stored
C) Database management programs
D) Query results
Answer: B
8. What is the determining characteristic of unstructured data?
A) It follows a strict data model
B) It does not follow a data model
C) It is stored in relational tables
D) It has a hierarchical structure
Answer: B
9. What is true about Flat files?
A) They contain extensive hierarchical organization
B) They contain no internal hierarchical organization
C) They are always indexed
D) They support complex relationships
Answer: B
Foundations OA Exam Actual Exam 2 Latest Versions | 300
Questions & Detailed Answers | 2026 Updated Objective
Assessment Study Guide | DBMS, SQL, ERD, Normalization,
Data Warehousing
THIS EXAM INCLUDE:
• Database Management Systems (DBMS)
• Relational Database Concepts
• SQL Fundamentals
• Data Modeling
• Detailed Answer
• GradedA+
• New Update 2026
, WGU C175 / D426 Data Management Foundations OA Exam
Actual Exam 2 Latest Versions | 300+ Questions & Detailed
Answers | 2026 Updated Objective Assessment Study Guide
| DBMS, SQL, ERD, Normalization, Data Warehousing
1. What does modality refer to in an ER diagram?
A) The maximum number of times an instance can be
associated
B) The minimum number of times an instance can be
associated
C) The total number of entities in a relationship
D) The number of attributes in an entity
Answer: B
2. What does Referential Integrity require?
A) All primary keys must be unique
B) All foreign key values must either be fully NULL or match
some primary key value
C) All tables must be in 3NF
D) No duplicate rows are allowed in any table
Answer: B
3. Which of the following is NOT a way Referential Integrity can
be violated?
, A) Primary key is updated
B) Foreign key is updated
C) Row containing primary key is INSERTED
D) Row containing foreign key is INSERTED
Answer: C
4. Which action to correct Referential Integrity violation sets
invalid foreign keys to null?
A) RESTRICT
B) SET NULL
C) SET DEFAULT
D) CASCADE
Answer: B
5. What is the important aspect of Referential Integrity?
A) Data is stored in a single location
B) Reference to data in one relation is based on values in
another relation
C) All tables must have a foreign key
D) Data must be normalized to 3NF
Answer: B
6. What is the broad definition of data?
A) Processed information stored in databases
B) Raw facts captured on printed or digital media
, C) Organized collections of related records
D) Metadata about database structures
Answer: B
7. What are data in a database system?
A) Processed information
B) Facts that are collected and stored
C) Database management programs
D) Query results
Answer: B
8. What is the determining characteristic of unstructured data?
A) It follows a strict data model
B) It does not follow a data model
C) It is stored in relational tables
D) It has a hierarchical structure
Answer: B
9. What is true about Flat files?
A) They contain extensive hierarchical organization
B) They contain no internal hierarchical organization
C) They are always indexed
D) They support complex relationships
Answer: B
