WGU C170 Data Management
Applications Exam With Actual Questions
& Verified Answers,Plus
Rationales/Expert Verified For
Guaranteed Pass 2025/2026 /Latest
Update/Instant Download Pdf
1. Which of the following is a primary key in a database table?
a. A field that can have duplicate values
b. A field that uniquely identifies each record **
c. A field used for sorting records
d. A field that stores large amounts of text
Answer: b
Rationale: A primary key uniquely identifies each record in a table and cannot contain NULL
values.
2. What does SQL stand for?
a. Structured Query List
b. Simple Query Language
c. Structured Query Language **
d. Standard Question Language
Answer: c
Rationale: SQL is the standard language used to communicate with and manipulate
relational databases.
3. Which SQL statement is used to retrieve data from a database?
a. INSERT
b. UPDATE
c. DELETE
d. SELECT **
Answer: d
Rationale: The SELECT statement is used to query and retrieve data from a database.
, 4. Which of the following is a type of relationship in a relational database?
a. One-to-One **
b. Many-to-Many
c. One-to-Many
d. All of the above **
Answer: d
Rationale: Relational databases support one-to-one, one-to-many, and many-to-many
relationships between tables.
5. What is the purpose of normalization in database design?
a. To improve storage speed
b. To reduce redundancy and improve data integrity **
c. To make data entry faster
d. To increase the number of tables
Answer: b
Rationale: Normalization organizes data to minimize redundancy and ensure data integrity.
6. Which SQL clause is used to filter records based on a condition?
a. ORDER BY
b. WHERE **
c. GROUP BY
d. HAVING
Answer: b
Rationale: The WHERE clause filters records in a query based on specified conditions.
7. Which SQL command is used to add a new record to a table?
a. ADD
b. INSERT **
c. UPDATE
d. CREATE
Answer: b
Rationale: INSERT INTO adds new rows to a table.
8. What does a foreign key do in a relational database?
a. Uniquely identifies a record
b. Enforces referential integrity between tables **
c. Automatically indexes data
d. Stores binary data
Answer: b
Rationale: A foreign key establishes a link between two tables and enforces referential
integrity.
, 9. Which of the following is a valid SQL aggregate function?
a. COUNT **
b. FIND
c. SEARCH
d. ADD
Answer: a
Rationale: COUNT, SUM, AVG, MIN, and MAX are common SQL aggregate functions.
10. What is a view in a database?
a. A physical copy of data
b. A virtual table based on a query **
c. A type of index
d. A method of backup
Answer: b
Rationale: A view is a virtual table created from a SELECT query; it does not store data
physically.
11. Which of the following ensures that a column cannot have NULL values?
a. PRIMARY KEY
b. UNIQUE
c. NOT NULL **
d. FOREIGN KEY
Answer: c
Rationale: The NOT NULL constraint ensures that a column must have a value.
12. Which operation removes all records from a table without deleting the table
structure?
a. DELETE **
b. DROP
c. TRUNCATE **
d. REMOVE
Answer: c
Rationale: TRUNCATE removes all rows from a table but keeps the table structure.
13. What type of data is best stored in a BLOB column?
a. Text
b. Binary large objects like images **
c. Numbers
d. Dates
Answer: b
Rationale: BLOB columns store large binary data such as images or multimedia files.
Applications Exam With Actual Questions
& Verified Answers,Plus
Rationales/Expert Verified For
Guaranteed Pass 2025/2026 /Latest
Update/Instant Download Pdf
1. Which of the following is a primary key in a database table?
a. A field that can have duplicate values
b. A field that uniquely identifies each record **
c. A field used for sorting records
d. A field that stores large amounts of text
Answer: b
Rationale: A primary key uniquely identifies each record in a table and cannot contain NULL
values.
2. What does SQL stand for?
a. Structured Query List
b. Simple Query Language
c. Structured Query Language **
d. Standard Question Language
Answer: c
Rationale: SQL is the standard language used to communicate with and manipulate
relational databases.
3. Which SQL statement is used to retrieve data from a database?
a. INSERT
b. UPDATE
c. DELETE
d. SELECT **
Answer: d
Rationale: The SELECT statement is used to query and retrieve data from a database.
, 4. Which of the following is a type of relationship in a relational database?
a. One-to-One **
b. Many-to-Many
c. One-to-Many
d. All of the above **
Answer: d
Rationale: Relational databases support one-to-one, one-to-many, and many-to-many
relationships between tables.
5. What is the purpose of normalization in database design?
a. To improve storage speed
b. To reduce redundancy and improve data integrity **
c. To make data entry faster
d. To increase the number of tables
Answer: b
Rationale: Normalization organizes data to minimize redundancy and ensure data integrity.
6. Which SQL clause is used to filter records based on a condition?
a. ORDER BY
b. WHERE **
c. GROUP BY
d. HAVING
Answer: b
Rationale: The WHERE clause filters records in a query based on specified conditions.
7. Which SQL command is used to add a new record to a table?
a. ADD
b. INSERT **
c. UPDATE
d. CREATE
Answer: b
Rationale: INSERT INTO adds new rows to a table.
8. What does a foreign key do in a relational database?
a. Uniquely identifies a record
b. Enforces referential integrity between tables **
c. Automatically indexes data
d. Stores binary data
Answer: b
Rationale: A foreign key establishes a link between two tables and enforces referential
integrity.
, 9. Which of the following is a valid SQL aggregate function?
a. COUNT **
b. FIND
c. SEARCH
d. ADD
Answer: a
Rationale: COUNT, SUM, AVG, MIN, and MAX are common SQL aggregate functions.
10. What is a view in a database?
a. A physical copy of data
b. A virtual table based on a query **
c. A type of index
d. A method of backup
Answer: b
Rationale: A view is a virtual table created from a SELECT query; it does not store data
physically.
11. Which of the following ensures that a column cannot have NULL values?
a. PRIMARY KEY
b. UNIQUE
c. NOT NULL **
d. FOREIGN KEY
Answer: c
Rationale: The NOT NULL constraint ensures that a column must have a value.
12. Which operation removes all records from a table without deleting the table
structure?
a. DELETE **
b. DROP
c. TRUNCATE **
d. REMOVE
Answer: c
Rationale: TRUNCATE removes all rows from a table but keeps the table structure.
13. What type of data is best stored in a BLOB column?
a. Text
b. Binary large objects like images **
c. Numbers
d. Dates
Answer: b
Rationale: BLOB columns store large binary data such as images or multimedia files.
