WGU D426 V3 DATA MANAGEMENT
FOUNDATIONS COMPREHENSIVE
MASTERY TEST QUESTIONS AND
ANSWERS
1. Which normal form is specifically designed to eliminate transitive dependencies by
ensuring every non-key attribute is dependent only on the primary key?
A. Third Normal Form (3NF)
B. Second Normal Form (2NF)
C. First Normal Form (1NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: A
Conceptual Explanation: 3NF requires the relation to be in 2NF and that no non-key
attribute is transitively dependent on the primary key.
2. In a relational database, which key is defined as a minimal set of attributes that uniquely
identifies a tuple, where no subset of the attributes is itself a superkey?
A. Primary Key
,B. Alternate Key
C. Foreign Key
D. Candidate Key
Answer: D
Conceptual Explanation: A candidate key is a minimal superkey. While a primary key is a
chosen candidate key, the definition of a minimal set refers to candidate keys in general.
3. Which SQL statement is used to remove all records from a table without deleting the table
structure itself, typically acting faster than a DELETE statement?
A. TRUNCATE TABLE
B. REMOVE ALL
C. DELETE *
D. DROP TABLE
Answer: A
Conceptual Explanation: TRUNCATE is a DDL command that removes all rows from a
table, whereas DELETE is a DML command that can remove specific or all rows but is
usually logged and slower.
4. During the Database Design Life Cycle, in which phase are Entity-Relationship Diagrams
(ERDs) mapped into tables, columns, and keys for a specific DBMS?
A. Logical Design
, B. Physical Design
C. Conceptual Design
D. Requirement Analysis
Answer: A
Conceptual Explanation: Logical Design involves mapping the conceptual model (ERD) to
a relational model (tables and keys) without concerning the specific storage hardware.
5. In an ERD, what does a dashed line between two entities typically signify in Crow’s Foot
notation?
A. Identifying Relationship
B. Non-identifying Relationship
C. Mandatory Relationship
D. Recursive Relationship
Answer: B
Conceptual Explanation: A dashed line indicates a non-identifying relationship, meaning
the child entity can exist independently of the parent and the parent’s PK is not part of the
child’s PK.
6. Which type of integrity constraint ensures that a value in a column must exist in a related
table’s primary key column?
A. Entity Integrity
FOUNDATIONS COMPREHENSIVE
MASTERY TEST QUESTIONS AND
ANSWERS
1. Which normal form is specifically designed to eliminate transitive dependencies by
ensuring every non-key attribute is dependent only on the primary key?
A. Third Normal Form (3NF)
B. Second Normal Form (2NF)
C. First Normal Form (1NF)
D. Boyce-Codd Normal Form (BCNF)
Answer: A
Conceptual Explanation: 3NF requires the relation to be in 2NF and that no non-key
attribute is transitively dependent on the primary key.
2. In a relational database, which key is defined as a minimal set of attributes that uniquely
identifies a tuple, where no subset of the attributes is itself a superkey?
A. Primary Key
,B. Alternate Key
C. Foreign Key
D. Candidate Key
Answer: D
Conceptual Explanation: A candidate key is a minimal superkey. While a primary key is a
chosen candidate key, the definition of a minimal set refers to candidate keys in general.
3. Which SQL statement is used to remove all records from a table without deleting the table
structure itself, typically acting faster than a DELETE statement?
A. TRUNCATE TABLE
B. REMOVE ALL
C. DELETE *
D. DROP TABLE
Answer: A
Conceptual Explanation: TRUNCATE is a DDL command that removes all rows from a
table, whereas DELETE is a DML command that can remove specific or all rows but is
usually logged and slower.
4. During the Database Design Life Cycle, in which phase are Entity-Relationship Diagrams
(ERDs) mapped into tables, columns, and keys for a specific DBMS?
A. Logical Design
, B. Physical Design
C. Conceptual Design
D. Requirement Analysis
Answer: A
Conceptual Explanation: Logical Design involves mapping the conceptual model (ERD) to
a relational model (tables and keys) without concerning the specific storage hardware.
5. In an ERD, what does a dashed line between two entities typically signify in Crow’s Foot
notation?
A. Identifying Relationship
B. Non-identifying Relationship
C. Mandatory Relationship
D. Recursive Relationship
Answer: B
Conceptual Explanation: A dashed line indicates a non-identifying relationship, meaning
the child entity can exist independently of the parent and the parent’s PK is not part of the
child’s PK.
6. Which type of integrity constraint ensures that a value in a column must exist in a related
table’s primary key column?
A. Entity Integrity
