Spring Semester February 2026 WGU C175 Data
Management Foundations Objective Assessment
(OA) Exam Prep | Database Fundamentals,
Relational Models, SQL Basics, Data Normalization,
ER Diagrams, Data Integrity, Structured Query
Language Concepts, Database Design & Data
Governance Study Guide with Practice Questions
, Question 1: What is the primary purpose of a database management system
(DBMS)?
a) To store data permanently
b) To retrieve and manipulate data
c) To provide security measures
d) All of the above
Correct Option: d) All of the above
Rationale: A DBMS serves multiple purposes, including storing data permanently,
retrieving and manipulating data as needed, and implementing security measures to
protect the data. Together, these functions facilitate efficient data management and
accessibility.
Question 2: Which of the following is NOT a type of database model?
a) Hierarchical
b) Network
c) Relational
d) Cursive
Correct Option: d) Cursive
Rationale: The hierarchical, network, and relational models are established types of
database models used to organize and manage data. "Cursive" is not recognized as a
database model, making this option incorrect.
Question 3: In SQL, which command is used to remove a table from a database?
a) DELETE TABLE
b) DROP TABLE
c) REMOVE TABLE
d) CLEAR TABLE
Correct Option: b) DROP TABLE
Rationale: The SQL command DROP TABLE is specifically used to remove a table and
all its data from the database. Other options do not exist as SQL commands for this
operation, making this the correct choice.
Question 4: What is normalization in the context of databases?
a) Reducing data redundancy
b) Increasing data redundancy
c) Encrypting data
d) Compressing data
Correct Option: a) Reducing data redundancy
Rationale: Normalization is a database design technique that aims to reduce data
Management Foundations Objective Assessment
(OA) Exam Prep | Database Fundamentals,
Relational Models, SQL Basics, Data Normalization,
ER Diagrams, Data Integrity, Structured Query
Language Concepts, Database Design & Data
Governance Study Guide with Practice Questions
, Question 1: What is the primary purpose of a database management system
(DBMS)?
a) To store data permanently
b) To retrieve and manipulate data
c) To provide security measures
d) All of the above
Correct Option: d) All of the above
Rationale: A DBMS serves multiple purposes, including storing data permanently,
retrieving and manipulating data as needed, and implementing security measures to
protect the data. Together, these functions facilitate efficient data management and
accessibility.
Question 2: Which of the following is NOT a type of database model?
a) Hierarchical
b) Network
c) Relational
d) Cursive
Correct Option: d) Cursive
Rationale: The hierarchical, network, and relational models are established types of
database models used to organize and manage data. "Cursive" is not recognized as a
database model, making this option incorrect.
Question 3: In SQL, which command is used to remove a table from a database?
a) DELETE TABLE
b) DROP TABLE
c) REMOVE TABLE
d) CLEAR TABLE
Correct Option: b) DROP TABLE
Rationale: The SQL command DROP TABLE is specifically used to remove a table and
all its data from the database. Other options do not exist as SQL commands for this
operation, making this the correct choice.
Question 4: What is normalization in the context of databases?
a) Reducing data redundancy
b) Increasing data redundancy
c) Encrypting data
d) Compressing data
Correct Option: a) Reducing data redundancy
Rationale: Normalization is a database design technique that aims to reduce data
