WGU D426 DATA MANAGEMENT
FOUNDATIONS ADVANCED PRACTICE
EXAM
1. Which normal form is specifically concerned with removing partial functional
dependencies?
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 the table is in 1NF and
all non-key attributes are fully functionally dependent on the entire primary key, thereby
eliminating partial dependencies.
,2. In the context of the ACID properties of a database transaction, which property ensures
that once a transaction is committed, it remains committed even in the case of a system
failure?
A. Atomicity
B. Consistency
C. Durability
D. Isolation
Answer: C
Conceptual Explanation: Durability ensures that the results of a committed transaction
are permanently recorded in the database and survive any subsequent system failures.
3. Which SQL clause is used to filter the results of a GROUP BY operation based on a specific
condition?
A. WHERE
B. ORDER BY
C. LIMIT
D. HAVING
Answer: D
, Conceptual Explanation: The HAVING clause is used to filter groups created by the
GROUP BY clause. Unlike WHERE, which filters rows before grouping, HAVING filters the
groups themselves.
4. What is the primary difference between a ‘identifying’ and ‘non-identifying’ relationship in
an ERD?
A. An identifying relationship uses a dashed line, while non-identifying uses a solid line.
B. An identifying relationship exists when the primary key of the child entity contains the
primary key of the parent entity.
C. A non-identifying relationship requires a junction table, whereas an identifying
relationship does not.
D. Identifying relationships only occur in many-to-many scenarios.
Answer: B
Conceptual Explanation: In an identifying relationship, the child entity’s identity is
dependent on the parent, meaning the parent’s primary key is part of the child’s primary
key.
5. Which command is used in SQL to remove all records from a table without deleting the
table structure itself, and is generally faster than a DELETE command?
A. TRUNCATE
B. REMOVE
C. DROP
FOUNDATIONS ADVANCED PRACTICE
EXAM
1. Which normal form is specifically concerned with removing partial functional
dependencies?
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 the table is in 1NF and
all non-key attributes are fully functionally dependent on the entire primary key, thereby
eliminating partial dependencies.
,2. In the context of the ACID properties of a database transaction, which property ensures
that once a transaction is committed, it remains committed even in the case of a system
failure?
A. Atomicity
B. Consistency
C. Durability
D. Isolation
Answer: C
Conceptual Explanation: Durability ensures that the results of a committed transaction
are permanently recorded in the database and survive any subsequent system failures.
3. Which SQL clause is used to filter the results of a GROUP BY operation based on a specific
condition?
A. WHERE
B. ORDER BY
C. LIMIT
D. HAVING
Answer: D
, Conceptual Explanation: The HAVING clause is used to filter groups created by the
GROUP BY clause. Unlike WHERE, which filters rows before grouping, HAVING filters the
groups themselves.
4. What is the primary difference between a ‘identifying’ and ‘non-identifying’ relationship in
an ERD?
A. An identifying relationship uses a dashed line, while non-identifying uses a solid line.
B. An identifying relationship exists when the primary key of the child entity contains the
primary key of the parent entity.
C. A non-identifying relationship requires a junction table, whereas an identifying
relationship does not.
D. Identifying relationships only occur in many-to-many scenarios.
Answer: B
Conceptual Explanation: In an identifying relationship, the child entity’s identity is
dependent on the parent, meaning the parent’s primary key is part of the child’s primary
key.
5. Which command is used in SQL to remove all records from a table without deleting the
table structure itself, and is generally faster than a DELETE command?
A. TRUNCATE
B. REMOVE
C. DROP
