WGU C170 Data Management
Applications Assessment 2026/2027 –
Verified Q&As with Detailed Rationales
(Test Bank Bundle - 46 Questions)
---
*QUESTION 1:*
A database administrator is designing a new database. What is the first step in the design process?
A) Define the requirements and objectives
B) Create the physical database
C) Write SQL queries
D) Implement security measures
> 🎯 *CORRECT ANSWER:* A) Define the requirements and objectives
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* Requirements gathering is the foundation of database design.
> * *Why Distractors Fail:* Physical creation, queries, and security come later.
> * *Core Takeaway:* Start with requirements.
---
*QUESTION 2:*
A database table has a column that stores product prices. What is the most appropriate data type?
A) DECIMAL
,B) VARCHAR
C) DATE
D) INTEGER
> 🎯 *CORRECT ANSWER:* A) DECIMAL
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* DECIMAL is used for precise monetary values.
> * *Why Distractors Fail:* VARCHAR is for strings; DATE is for dates; INTEGER is for whole numbers.
> * *Core Takeaway:* Use DECIMAL for prices.
---
*QUESTION 3:*
Which SQL statement is used to create a new table?
A) CREATE TABLE
B) ALTER TABLE
C) DROP TABLE
D) INSERT INTO
> 🎯 *CORRECT ANSWER:* A) CREATE TABLE
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* CREATE TABLE defines a new table structure.
> * *Why Distractors Fail:* ALTER modifies; DROP deletes; INSERT adds data.
> * *Core Takeaway:* CREATE TABLE is for table creation.
---
*QUESTION 4:*
A developer wants to add a new column to an existing table. Which SQL statement is used?
, A) ALTER TABLE ADD
B) CREATE TABLE ADD
C) UPDATE TABLE ADD
D) MODIFY TABLE ADD
> 🎯 *CORRECT ANSWER:* A) ALTER TABLE ADD
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* ALTER TABLE ADD adds a column.
> * *Why Distractors Fail:* CREATE creates a new table; UPDATE modifies data.
> * *Core Takeaway:* ALTER TABLE ADD adds columns.
---
*QUESTION 5:*
A database table has a primary key constraint. What is the purpose of a primary key?
A) To uniquely identify each row
B) To create a relationship with another table
C) To sort the data
D) To enforce data types
> 🎯 *CORRECT ANSWER:* A) To uniquely identify each row
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* Primary keys ensure uniqueness.
> * *Why Distractors Fail:* Foreign keys create relationships; sorting and data types are separate.
> * *Core Takeaway:* Primary keys enforce uniqueness.
---
*QUESTION 6:*
Applications Assessment 2026/2027 –
Verified Q&As with Detailed Rationales
(Test Bank Bundle - 46 Questions)
---
*QUESTION 1:*
A database administrator is designing a new database. What is the first step in the design process?
A) Define the requirements and objectives
B) Create the physical database
C) Write SQL queries
D) Implement security measures
> 🎯 *CORRECT ANSWER:* A) Define the requirements and objectives
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* Requirements gathering is the foundation of database design.
> * *Why Distractors Fail:* Physical creation, queries, and security come later.
> * *Core Takeaway:* Start with requirements.
---
*QUESTION 2:*
A database table has a column that stores product prices. What is the most appropriate data type?
A) DECIMAL
,B) VARCHAR
C) DATE
D) INTEGER
> 🎯 *CORRECT ANSWER:* A) DECIMAL
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* DECIMAL is used for precise monetary values.
> * *Why Distractors Fail:* VARCHAR is for strings; DATE is for dates; INTEGER is for whole numbers.
> * *Core Takeaway:* Use DECIMAL for prices.
---
*QUESTION 3:*
Which SQL statement is used to create a new table?
A) CREATE TABLE
B) ALTER TABLE
C) DROP TABLE
D) INSERT INTO
> 🎯 *CORRECT ANSWER:* A) CREATE TABLE
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* CREATE TABLE defines a new table structure.
> * *Why Distractors Fail:* ALTER modifies; DROP deletes; INSERT adds data.
> * *Core Takeaway:* CREATE TABLE is for table creation.
---
*QUESTION 4:*
A developer wants to add a new column to an existing table. Which SQL statement is used?
, A) ALTER TABLE ADD
B) CREATE TABLE ADD
C) UPDATE TABLE ADD
D) MODIFY TABLE ADD
> 🎯 *CORRECT ANSWER:* A) ALTER TABLE ADD
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* ALTER TABLE ADD adds a column.
> * *Why Distractors Fail:* CREATE creates a new table; UPDATE modifies data.
> * *Core Takeaway:* ALTER TABLE ADD adds columns.
---
*QUESTION 5:*
A database table has a primary key constraint. What is the purpose of a primary key?
A) To uniquely identify each row
B) To create a relationship with another table
C) To sort the data
D) To enforce data types
> 🎯 *CORRECT ANSWER:* A) To uniquely identify each row
> 💡 *CLINICAL RATIONALE:*
> * *Why It's Right:* Primary keys ensure uniqueness.
> * *Why Distractors Fail:* Foreign keys create relationships; sorting and data types are separate.
> * *Core Takeaway:* Primary keys enforce uniqueness.
---
*QUESTION 6:*
