C175 DATA MANAGEMENT FOUNDATIONS PRACTICE TEST
with Answer Key | WGU C175 Objective
Assessment Practice Questions & Detailed
Explanations | Latest 2026 Study Guide
THIS EXAM INCLUDE:
• Practice Questions with Detailed Answers
• Database Management System (DBMS) Fundamentals
• Relational Database Concepts
• SQL Basics (SELECT, INSERT, UPDATE, DELETE)
• Objective Assessment Review
• Detailed Answer Explanations
• All graded A+
• New 2026
,Data Management Foundations Practice Test
x x x x
Multiple Choice x
Identify the choice that best completes the statement or answers the question.
x x x x x x x x x x x
1. A record consists of a
x . x x x x
a. character
b. collection of related records x x x
c. set of one or more fields x x x x x
d. group of files x x
2. A DBMS performs several important functions that guarantee the integrity and consistency of the data in
x x x x x x x x x x x x x x x
the database. Which of the following is NOT one of those functions?
x x x x x x x x x x x x
a. Data integrity management x x
b. Data storage management x x
c. Data reports x
d. Security management x
3. Which item is unstructured data.
x x x x
a. A record representing one student
x x x x
b. A video x
c. A table that holds student data
x x x x x
d. A relational database that hold course registration data.
x x x x x x x
4. Data is/are: x
a. information
b. raw facts x
c. processed information x
d. a DBMS x
5.
Which classification is correct for the box marked “Registration” in the given E-R Diagram?
x x x x x x x x x x x x x
a. Intersection data x
b. Modality data x
c. Cardinality data x
, d. Student data x
6.
Which type of relationship exists between Student and Course
x x x x x x x x
a. One-to-many binary x
b. Many-to-many binary x
c. One-to-many unary x
d. Many-to-many unary x
7.
What is the E-R Diagram about an online pet food vendor showing?
x x x x x x x x x x x
a. An Invoice Line can include many Items
x x x x x x
b. An item can only be included in one Invoice Line
x x x x x x x x x
c. One Invoice Line must include a minimum of one and a maximum of one Item.
x x x x x x x x x x x x x x
d. The relationship between Item and Invoice Line is many-to-many.
x x x x x x x x
8. x x A pet owner can have many pets; a specific pet is linked to one pet owner.
x x x x x x x x x x x x x x x
Which kind of binary relationship is described in this example?
x x x x x x x x x
a. One-to-one
b. One-to-many
c. Many-to-many
with Answer Key | WGU C175 Objective
Assessment Practice Questions & Detailed
Explanations | Latest 2026 Study Guide
THIS EXAM INCLUDE:
• Practice Questions with Detailed Answers
• Database Management System (DBMS) Fundamentals
• Relational Database Concepts
• SQL Basics (SELECT, INSERT, UPDATE, DELETE)
• Objective Assessment Review
• Detailed Answer Explanations
• All graded A+
• New 2026
,Data Management Foundations Practice Test
x x x x
Multiple Choice x
Identify the choice that best completes the statement or answers the question.
x x x x x x x x x x x
1. A record consists of a
x . x x x x
a. character
b. collection of related records x x x
c. set of one or more fields x x x x x
d. group of files x x
2. A DBMS performs several important functions that guarantee the integrity and consistency of the data in
x x x x x x x x x x x x x x x
the database. Which of the following is NOT one of those functions?
x x x x x x x x x x x x
a. Data integrity management x x
b. Data storage management x x
c. Data reports x
d. Security management x
3. Which item is unstructured data.
x x x x
a. A record representing one student
x x x x
b. A video x
c. A table that holds student data
x x x x x
d. A relational database that hold course registration data.
x x x x x x x
4. Data is/are: x
a. information
b. raw facts x
c. processed information x
d. a DBMS x
5.
Which classification is correct for the box marked “Registration” in the given E-R Diagram?
x x x x x x x x x x x x x
a. Intersection data x
b. Modality data x
c. Cardinality data x
, d. Student data x
6.
Which type of relationship exists between Student and Course
x x x x x x x x
a. One-to-many binary x
b. Many-to-many binary x
c. One-to-many unary x
d. Many-to-many unary x
7.
What is the E-R Diagram about an online pet food vendor showing?
x x x x x x x x x x x
a. An Invoice Line can include many Items
x x x x x x
b. An item can only be included in one Invoice Line
x x x x x x x x x
c. One Invoice Line must include a minimum of one and a maximum of one Item.
x x x x x x x x x x x x x x
d. The relationship between Item and Invoice Line is many-to-many.
x x x x x x x x
8. x x A pet owner can have many pets; a specific pet is linked to one pet owner.
x x x x x x x x x x x x x x x
Which kind of binary relationship is described in this example?
x x x x x x x x x
a. One-to-one
b. One-to-many
c. Many-to-many
