WGU D426 DATA MANAGEMENT
FOUNDATIONS - PRACTICE EXAM V1 &
V2 QUESTIONS AND CORRECT
DETAILED ANSWERS A+ GRADE
1. Which normal form deals specifically with eliminating 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
that all non-key attributes are fully functionally dependent on the primary key, thereby
eliminating partial dependencies.
2. In an Entity-Relationship Diagram (ERD), what does a dashed line between two entities
typically represent?
A. A non-identifying relationship
B. An identifying relationship
C. A many-to-many relationship
,D. A recursive relationship
Answer: A
Conceptual Explanation: In Crow’s Foot notation, a dashed line represents a non-
identifying relationship, where the child entity can exist independently of the parent.
3. Which SQL command is categorized as Data Definition Language (DDL)?
A. ALTER
B. UPDATE
C. INSERT
D. SELECT
Answer: A
Conceptual Explanation: DDL commands like CREATE, ALTER, and DROP define or
modify the structure of the database. INSERT and UPDATE are DML, and SELECT is DQL.
4. What is the purpose of a ‘Weak Entity’ in database design?
A. It represents an entity that has no attributes.
B. It is an entity used only for backup purposes.
C. It represents a table with no primary key.
D. It represents an entity that cannot be uniquely identified by its own attributes alone.
Answer: D
, Conceptual Explanation: A weak entity depends on a strong entity for its identification
and usually uses a foreign key as part of its composite primary key.
5. A relationship where a single record in Table A can be related to many records in Table B,
but a record in Table B can only be related to one record in Table A is called:
A. One-to-One
B. Many-to-Many
C. One-to-Many
D. Recursive
Answer: C
Conceptual Explanation: This is the definition of a One-to-Many (1:M) relationship, which
is the most common type in relational databases.
6. Which normal form is violated if a non-key attribute is dependent on another non-key
attribute?
A. 1NF
B. 3NF
C. 2NF
D. BCNF
Answer: B
FOUNDATIONS - PRACTICE EXAM V1 &
V2 QUESTIONS AND CORRECT
DETAILED ANSWERS A+ GRADE
1. Which normal form deals specifically with eliminating 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
that all non-key attributes are fully functionally dependent on the primary key, thereby
eliminating partial dependencies.
2. In an Entity-Relationship Diagram (ERD), what does a dashed line between two entities
typically represent?
A. A non-identifying relationship
B. An identifying relationship
C. A many-to-many relationship
,D. A recursive relationship
Answer: A
Conceptual Explanation: In Crow’s Foot notation, a dashed line represents a non-
identifying relationship, where the child entity can exist independently of the parent.
3. Which SQL command is categorized as Data Definition Language (DDL)?
A. ALTER
B. UPDATE
C. INSERT
D. SELECT
Answer: A
Conceptual Explanation: DDL commands like CREATE, ALTER, and DROP define or
modify the structure of the database. INSERT and UPDATE are DML, and SELECT is DQL.
4. What is the purpose of a ‘Weak Entity’ in database design?
A. It represents an entity that has no attributes.
B. It is an entity used only for backup purposes.
C. It represents a table with no primary key.
D. It represents an entity that cannot be uniquely identified by its own attributes alone.
Answer: D
, Conceptual Explanation: A weak entity depends on a strong entity for its identification
and usually uses a foreign key as part of its composite primary key.
5. A relationship where a single record in Table A can be related to many records in Table B,
but a record in Table B can only be related to one record in Table A is called:
A. One-to-One
B. Many-to-Many
C. One-to-Many
D. Recursive
Answer: C
Conceptual Explanation: This is the definition of a One-to-Many (1:M) relationship, which
is the most common type in relational databases.
6. Which normal form is violated if a non-key attribute is dependent on another non-key
attribute?
A. 1NF
B. 3NF
C. 2NF
D. BCNF
Answer: B
