WGU D427 DATA MANAGEMENT
APPLICATIONS COMPREHENSIVE
PRACTICE EXAM QUESTIONS AND
ANSWERS
1. Which normal form requires the removal of partial functional dependencies where a non-
key attribute is dependent on only part of a composite primary key?
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: Second Normal Form (2NF) specifically addresses partial
dependencies, ensuring that every non-prime attribute is fully functionally dependent on
the entire primary key.
2. In a relational database, what is the primary purpose of a Foreign Key?
A. To uniquely identify each record in a table.
,B. To improve the speed of data retrieval.
C. To ensure that a column cannot have a NULL value.
D. To establish and enforce a link between data in two tables.
Answer: D
Conceptual Explanation: A Foreign Key is a field (or collection of fields) in one table that
refers to the Primary Key in another table, maintaining referential integrity between the
two.
3. Which SQL statement is used to remove all records from a table without logging individual
row deletions, effectively resetting the table while keeping its structure?
A. TRUNCATE
B. DROP
C. REMOVE
D. DELETE
Answer: A
Conceptual Explanation: TRUNCATE TABLE is a DDL operation that removes all rows
from a table and is generally faster than DELETE because it does not generate individual
row delete logs.
, 4. Which of the following describes a ‘transitive dependency’ in the context of database
normalization?
A. A non-key attribute depends on another non-key attribute.
B. A non-key attribute depends on only a portion of the primary key.
C. Multiple primary keys pointing to the same record.
D. An attribute that is dependent on itself.
Answer: A
Conceptual Explanation: A transitive dependency occurs when a non-key attribute is
functionally dependent on another non-key attribute, which is a violation of 3NF.
5. In the Crow’s Foot notation of an ERD, what does a dashed line between two entities
represent?
A. An identifying relationship.
B. A many-to-many relationship.
C. A non-identifying relationship.
D. A recursive relationship.
Answer: C
Conceptual Explanation: In Crow’s Foot notation, a dashed line signifies a non-identifying
relationship where the child entity can exist independently of the parent.
APPLICATIONS COMPREHENSIVE
PRACTICE EXAM QUESTIONS AND
ANSWERS
1. Which normal form requires the removal of partial functional dependencies where a non-
key attribute is dependent on only part of a composite primary key?
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: Second Normal Form (2NF) specifically addresses partial
dependencies, ensuring that every non-prime attribute is fully functionally dependent on
the entire primary key.
2. In a relational database, what is the primary purpose of a Foreign Key?
A. To uniquely identify each record in a table.
,B. To improve the speed of data retrieval.
C. To ensure that a column cannot have a NULL value.
D. To establish and enforce a link between data in two tables.
Answer: D
Conceptual Explanation: A Foreign Key is a field (or collection of fields) in one table that
refers to the Primary Key in another table, maintaining referential integrity between the
two.
3. Which SQL statement is used to remove all records from a table without logging individual
row deletions, effectively resetting the table while keeping its structure?
A. TRUNCATE
B. DROP
C. REMOVE
D. DELETE
Answer: A
Conceptual Explanation: TRUNCATE TABLE is a DDL operation that removes all rows
from a table and is generally faster than DELETE because it does not generate individual
row delete logs.
, 4. Which of the following describes a ‘transitive dependency’ in the context of database
normalization?
A. A non-key attribute depends on another non-key attribute.
B. A non-key attribute depends on only a portion of the primary key.
C. Multiple primary keys pointing to the same record.
D. An attribute that is dependent on itself.
Answer: A
Conceptual Explanation: A transitive dependency occurs when a non-key attribute is
functionally dependent on another non-key attribute, which is a violation of 3NF.
5. In the Crow’s Foot notation of an ERD, what does a dashed line between two entities
represent?
A. An identifying relationship.
B. A many-to-many relationship.
C. A non-identifying relationship.
D. A recursive relationship.
Answer: C
Conceptual Explanation: In Crow’s Foot notation, a dashed line signifies a non-identifying
relationship where the child entity can exist independently of the parent.
