WGU D427 DATA MANAGEMENT
APPLICATIONS COMPREHENSIVE
ASSESSMENT QUESTIONS AND
ANSWERS
1. Which normal form is reached when all partial functional dependencies have been
removed?
A. First Normal Form (1NF)
B. Third Normal Form (3NF)
C. Second Normal Form (2NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: C
Conceptual Explanation: Second Normal Form (2NF) requires that a table is in 1NF and
that all non-key attributes are fully functionally dependent on the primary key, meaning
partial dependencies are removed.
2. Which SQL statement is used to remove a specific row from a table?
A. REMOVE
,B. DROP
C. TRUNCATE
D. DELETE
Answer: D
Conceptual Explanation: The DELETE statement is used to remove existing records from
a table based on a WHERE clause. DROP removes whole structures, and TRUNCATE
removes all rows without logging individual deletions.
3. In a database, what is the purpose of a Foreign Key?
A. To uniquely identify a record in its own table.
B. To ensure that data in a column is unique across all rows.
C. To create a link between two tables by referencing a primary key.
D. To automatically increment a numerical value for each new entry.
Answer: C
Conceptual Explanation: A Foreign Key is a field (or collection of fields) in one table that
refers to the Primary Key in another table, establishing a relationship between the two.
4. Which SQL clause is used to filter the results of an aggregate function?
A. WHERE
B. HAVING
, C. GROUP BY
D. ORDER BY
Answer: B
Conceptual Explanation: The HAVING clause was added to SQL because the WHERE
keyword could not be used with aggregate functions; it filters groups created by the GROUP
BY clause.
5. Which of the following describes a ‘Transitive Dependency’?
A. A non-key attribute depends on another non-key attribute.
B. A non-key attribute depends on only part of a composite primary key.
C. Two tables share the same primary key.
D. A primary key depends on a foreign key.
Answer: A
Conceptual Explanation: Transitive dependency occurs when a non-key attribute is
dependent on another non-key attribute, which must be removed to achieve Third Normal
Form (3NF).
6. What is the default sort order of the ORDER BY clause in SQL?
A. Ascending (ASC)
B. Random
C. Descending (DESC)
APPLICATIONS COMPREHENSIVE
ASSESSMENT QUESTIONS AND
ANSWERS
1. Which normal form is reached when all partial functional dependencies have been
removed?
A. First Normal Form (1NF)
B. Third Normal Form (3NF)
C. Second Normal Form (2NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: C
Conceptual Explanation: Second Normal Form (2NF) requires that a table is in 1NF and
that all non-key attributes are fully functionally dependent on the primary key, meaning
partial dependencies are removed.
2. Which SQL statement is used to remove a specific row from a table?
A. REMOVE
,B. DROP
C. TRUNCATE
D. DELETE
Answer: D
Conceptual Explanation: The DELETE statement is used to remove existing records from
a table based on a WHERE clause. DROP removes whole structures, and TRUNCATE
removes all rows without logging individual deletions.
3. In a database, what is the purpose of a Foreign Key?
A. To uniquely identify a record in its own table.
B. To ensure that data in a column is unique across all rows.
C. To create a link between two tables by referencing a primary key.
D. To automatically increment a numerical value for each new entry.
Answer: C
Conceptual Explanation: A Foreign Key is a field (or collection of fields) in one table that
refers to the Primary Key in another table, establishing a relationship between the two.
4. Which SQL clause is used to filter the results of an aggregate function?
A. WHERE
B. HAVING
, C. GROUP BY
D. ORDER BY
Answer: B
Conceptual Explanation: The HAVING clause was added to SQL because the WHERE
keyword could not be used with aggregate functions; it filters groups created by the GROUP
BY clause.
5. Which of the following describes a ‘Transitive Dependency’?
A. A non-key attribute depends on another non-key attribute.
B. A non-key attribute depends on only part of a composite primary key.
C. Two tables share the same primary key.
D. A primary key depends on a foreign key.
Answer: A
Conceptual Explanation: Transitive dependency occurs when a non-key attribute is
dependent on another non-key attribute, which must be removed to achieve Third Normal
Form (3NF).
6. What is the default sort order of the ORDER BY clause in SQL?
A. Ascending (ASC)
B. Random
C. Descending (DESC)
