WGU D446 DATA MANAGEMENT -
APPLICATIONS COMPREHENSIVE
EXAM QUESTIONS WITH VERIFIED
ANSWERS
1. Which normal form specifically addresses the issue of partial functional dependencies?
A. Second Normal Form (2NF)
B. First Normal Form (1NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: A
Conceptual Explanation: 2NF requires that all non-prime attributes are fully functionally
dependent on the entire primary key, thereby eliminating partial dependencies.
2. In a SQL SELECT statement, which clause is used to filter groups of rows after an aggregate
function has been applied?
A. WHERE
B. ORDER BY
C. GROUP BY
,D. HAVING
Answer: D
Conceptual Explanation: The HAVING clause is used to filter groups based on a condition,
usually involving aggregate functions like SUM or COUNT.
3. Which type of join returns all rows from the left table and the matched rows from the right
table, with NULLs for unmatched right-side rows?
A. INNER JOIN
B. FULL OUTER JOIN
C. CROSS JOIN
D. LEFT JOIN
Answer: D
Conceptual Explanation: A LEFT JOIN returns all records from the left table and the
matched records from the right table; unmatched right records result in NULL values.
4. What is the primary difference between a TRUNCATE and a DELETE command in SQL?
A. DELETE is a DDL command, while TRUNCATE is a DML command.
B. TRUNCATE can be rolled back, while DELETE cannot.
C. DELETE can include a WHERE clause to filter rows, whereas TRUNCATE removes all
rows.
D. TRUNCATE only removes the data structure, not the rows.
, Answer: C
Conceptual Explanation: DELETE is a DML command that can use a WHERE clause for
selective removal; TRUNCATE is a DDL command that removes all rows without logging
individual row deletions.
5. A ‘transitive dependency’ is the primary focus of which normalization stage?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Fourth Normal Form (4NF)
Answer: C
Conceptual Explanation: 3NF is achieved when a table is in 2NF and no non-prime
attribute is transitively dependent on the primary key.
6. Which SQL keyword is used to eliminate duplicate rows from the results of a SELECT query?
A. UNIQUE
B. SINGLE
C. DISTINCT
D. ALL
Answer: C
APPLICATIONS COMPREHENSIVE
EXAM QUESTIONS WITH VERIFIED
ANSWERS
1. Which normal form specifically addresses the issue of partial functional dependencies?
A. Second Normal Form (2NF)
B. First Normal Form (1NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: A
Conceptual Explanation: 2NF requires that all non-prime attributes are fully functionally
dependent on the entire primary key, thereby eliminating partial dependencies.
2. In a SQL SELECT statement, which clause is used to filter groups of rows after an aggregate
function has been applied?
A. WHERE
B. ORDER BY
C. GROUP BY
,D. HAVING
Answer: D
Conceptual Explanation: The HAVING clause is used to filter groups based on a condition,
usually involving aggregate functions like SUM or COUNT.
3. Which type of join returns all rows from the left table and the matched rows from the right
table, with NULLs for unmatched right-side rows?
A. INNER JOIN
B. FULL OUTER JOIN
C. CROSS JOIN
D. LEFT JOIN
Answer: D
Conceptual Explanation: A LEFT JOIN returns all records from the left table and the
matched records from the right table; unmatched right records result in NULL values.
4. What is the primary difference between a TRUNCATE and a DELETE command in SQL?
A. DELETE is a DDL command, while TRUNCATE is a DML command.
B. TRUNCATE can be rolled back, while DELETE cannot.
C. DELETE can include a WHERE clause to filter rows, whereas TRUNCATE removes all
rows.
D. TRUNCATE only removes the data structure, not the rows.
, Answer: C
Conceptual Explanation: DELETE is a DML command that can use a WHERE clause for
selective removal; TRUNCATE is a DDL command that removes all rows without logging
individual row deletions.
5. A ‘transitive dependency’ is the primary focus of which normalization stage?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Fourth Normal Form (4NF)
Answer: C
Conceptual Explanation: 3NF is achieved when a table is in 2NF and no non-prime
attribute is transitively dependent on the primary key.
6. Which SQL keyword is used to eliminate duplicate rows from the results of a SELECT query?
A. UNIQUE
B. SINGLE
C. DISTINCT
D. ALL
Answer: C
