C175 DATA MANAGEMENT FOUNDATIONS PRACTICE TEST with Answer Key | WGU C175 Objective Assessment Practice Questions & Detailed Explanations | Latest 2026 Study Guide

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