WGU D426 DATA MANAGEMENT
FOUNDATIONS V1/V2 EXAM PREP
QUESTIONS AND CORRECT DETAILED
ANSWERS A+ GRADE
1. Which normal form is achieved 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 entire primary key,
thereby removing partial dependencies.
2. In a relational database, what is a ‘superkey’?
A. A key used to link two tables in a relationship
B. The minimal set of attributes required to identify a row
,C. A key that uniquely identifies a row but contains extra attributes not necessary for
identification
D. An attribute that is only unique within its own table
Answer: C
Conceptual Explanation: A superkey is any set of one or more attributes that together
allow us to identify a record uniquely in a relation. A candidate key is a minimal superkey.
3. Which SQL statement is used to remove a table’s structure and all its data from a
database?
A. DROP
B. TRUNCATE
C. DELETE
D. REMOVE
Answer: A
Conceptual Explanation: DROP TABLE removes the entire table definition as well as all
data, while DELETE and TRUNCATE only affect the data within the table.
4. A transitive dependency is specifically addressed in which stage of normalization?
A. 1NF
B. 3NF
C. 2NF
, D. BCNF
Answer: B
Conceptual Explanation: Third Normal Form (3NF) requires a table to be in 2NF and
mandates that no non-prime attribute is transitively dependent on the primary key.
5. What type of relationship is represented by a bridge (associative) table?
A. Many-to-Many (M:N)
B. One-to-Many (1:M)
C. One-to-One (1:1)
D. Unary relationship
Answer: A
Conceptual Explanation: In relational design, M:N relationships cannot be implemented
directly and must be broken down into two 1:M relationships using a bridge or associative
table.
6. Which of the following is an example of Data Definition Language (DDL)?
A. ALTER
B. UPDATE
C. SELECT
D. INSERT
FOUNDATIONS V1/V2 EXAM PREP
QUESTIONS AND CORRECT DETAILED
ANSWERS A+ GRADE
1. Which normal form is achieved 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 entire primary key,
thereby removing partial dependencies.
2. In a relational database, what is a ‘superkey’?
A. A key used to link two tables in a relationship
B. The minimal set of attributes required to identify a row
,C. A key that uniquely identifies a row but contains extra attributes not necessary for
identification
D. An attribute that is only unique within its own table
Answer: C
Conceptual Explanation: A superkey is any set of one or more attributes that together
allow us to identify a record uniquely in a relation. A candidate key is a minimal superkey.
3. Which SQL statement is used to remove a table’s structure and all its data from a
database?
A. DROP
B. TRUNCATE
C. DELETE
D. REMOVE
Answer: A
Conceptual Explanation: DROP TABLE removes the entire table definition as well as all
data, while DELETE and TRUNCATE only affect the data within the table.
4. A transitive dependency is specifically addressed in which stage of normalization?
A. 1NF
B. 3NF
C. 2NF
, D. BCNF
Answer: B
Conceptual Explanation: Third Normal Form (3NF) requires a table to be in 2NF and
mandates that no non-prime attribute is transitively dependent on the primary key.
5. What type of relationship is represented by a bridge (associative) table?
A. Many-to-Many (M:N)
B. One-to-Many (1:M)
C. One-to-One (1:1)
D. Unary relationship
Answer: A
Conceptual Explanation: In relational design, M:N relationships cannot be implemented
directly and must be broken down into two 1:M relationships using a bridge or associative
table.
6. Which of the following is an example of Data Definition Language (DDL)?
A. ALTER
B. UPDATE
C. SELECT
D. INSERT
