WGU D631 – ADVANCED DATA MANAGEMENT |
OBJECTIVE ASSESSMENT | OA | ACTUAL QUESTIONS
AND ANSWERS | 2026 UPDATE | 100% CORRECT!!
Domain 1: Relational Databases & Data Modeling
1. What is the primary purpose of normalization in a relational database?
Answer:
To reduce data redundancy and improve data integrity by organizing data into logical tables based on
dependencies.
2. Which normal form removes partial dependencies?
Answer:
Second Normal Form (2NF)
3. What type of dependency violates Third Normal Form (3NF)?
Answer:
Transitive dependency
4. What is a primary key?
Answer:
A unique identifier for each record in a table that cannot contain NULL values.
5. What is the function of a foreign key?
Answer:
To establish and enforce a relationship between two tables by referencing a primary key in another
table.
6. Which relationship type allows one record to relate to many records in another table?
, Answer:
One-to-many relationship
7. What is a composite key?
Answer:
A primary key made up of two or more attributes used together to uniquely identify a record.
8. Which database object stores data in rows and columns?
Answer:
Table
Domain 2: SQL Queries & Data Retrieval
9. Which SQL clause filters rows before grouping occurs?
Answer:
WHERE
10. Which SQL clause filters aggregated data?
Answer:
HAVING
11. What does the SQL JOIN keyword do?
Answer:
Combines rows from two or more tables based on a related column.
12. Which JOIN returns only matching rows from both tables?
Answer:
INNER JOIN
13. Which JOIN returns all records from the left table and matching records from the right table?
Answer:
LEFT OUTER JOIN
14. What is the purpose of the GROUP BY clause?
OBJECTIVE ASSESSMENT | OA | ACTUAL QUESTIONS
AND ANSWERS | 2026 UPDATE | 100% CORRECT!!
Domain 1: Relational Databases & Data Modeling
1. What is the primary purpose of normalization in a relational database?
Answer:
To reduce data redundancy and improve data integrity by organizing data into logical tables based on
dependencies.
2. Which normal form removes partial dependencies?
Answer:
Second Normal Form (2NF)
3. What type of dependency violates Third Normal Form (3NF)?
Answer:
Transitive dependency
4. What is a primary key?
Answer:
A unique identifier for each record in a table that cannot contain NULL values.
5. What is the function of a foreign key?
Answer:
To establish and enforce a relationship between two tables by referencing a primary key in another
table.
6. Which relationship type allows one record to relate to many records in another table?
, Answer:
One-to-many relationship
7. What is a composite key?
Answer:
A primary key made up of two or more attributes used together to uniquely identify a record.
8. Which database object stores data in rows and columns?
Answer:
Table
Domain 2: SQL Queries & Data Retrieval
9. Which SQL clause filters rows before grouping occurs?
Answer:
WHERE
10. Which SQL clause filters aggregated data?
Answer:
HAVING
11. What does the SQL JOIN keyword do?
Answer:
Combines rows from two or more tables based on a related column.
12. Which JOIN returns only matching rows from both tables?
Answer:
INNER JOIN
13. Which JOIN returns all records from the left table and matching records from the right table?
Answer:
LEFT OUTER JOIN
14. What is the purpose of the GROUP BY clause?
