WGU D668 OA | Objective Assessment | 53
Questions and Answers | 100% Correct.
Q1. A table has repeating groups (multiple phone
numbers in one column). Which normal form is violated?
A. 1NF
B. 2NF
C. 3NF
D. BCNF
Answer: A (1NF)
Rationale: First Normal Form requires atomic (indivisible)
values and no repeating groups.
Q2. A table is in 1NF and has a composite primary key
(OrderID, ProductID). The column “ProductName” depends
only on ProductID, not the full key. Which normal form is
violated?
A. 1NF
B. 2NF
1
,C. 3NF
D. 4NF
Answer: B (2NF)
Rationale: 2NF eliminates partial dependencies (non-key
attributes depending on part of a composite key).
Q3. A table is in 2NF but has a transitive dependency:
StudentID → MajorID → MajorName. Which normal form
is violated?
A. 1NF
B. 2NF
C. 3NF
D. BCNF
Answer: C (3NF)
Rationale: 3NF removes transitive dependencies (non-key
→ non-key).
Q4. Which normal form requires every determinant to be
a candidate key?
A. 2NF
2
,B. 3NF
C. BCNF
D. 4NF
Answer: C (BCNF)
Rationale: Boyce-Codd Normal Form is a stronger version
of 3NF.
Q5. In an ER diagram, a diamond represents:
A. Entity
B. Attribute
C. Relationship
D. Primary key
Answer: C (Relationship)
Rationale: Rectangles = entities, ellipses = attributes,
diamonds = relationships.
Q6. Which cardinality means one entity instance relates
to many of another, but not vice versa?
A. 1:1
B. 1:M
3
, C. M:N
D. M:1
Answer: B (1:M)
Rationale: One-to-many – e.g., one customer, many
orders.
Q7. A recursive relationship means:
A. Table relates to itself
B. Table relates to two others
C. Table has no primary key
D. Table has composite key
Answer: A (Table relates to itself)
Rationale: Example: Employee supervises other
Employees.
Q8. Which is a weak entity?
A. Has its own primary key
B. Existence depends on another entity
C. Always in 3NF
D. Cannot have attributes
4
Questions and Answers | 100% Correct.
Q1. A table has repeating groups (multiple phone
numbers in one column). Which normal form is violated?
A. 1NF
B. 2NF
C. 3NF
D. BCNF
Answer: A (1NF)
Rationale: First Normal Form requires atomic (indivisible)
values and no repeating groups.
Q2. A table is in 1NF and has a composite primary key
(OrderID, ProductID). The column “ProductName” depends
only on ProductID, not the full key. Which normal form is
violated?
A. 1NF
B. 2NF
1
,C. 3NF
D. 4NF
Answer: B (2NF)
Rationale: 2NF eliminates partial dependencies (non-key
attributes depending on part of a composite key).
Q3. A table is in 2NF but has a transitive dependency:
StudentID → MajorID → MajorName. Which normal form
is violated?
A. 1NF
B. 2NF
C. 3NF
D. BCNF
Answer: C (3NF)
Rationale: 3NF removes transitive dependencies (non-key
→ non-key).
Q4. Which normal form requires every determinant to be
a candidate key?
A. 2NF
2
,B. 3NF
C. BCNF
D. 4NF
Answer: C (BCNF)
Rationale: Boyce-Codd Normal Form is a stronger version
of 3NF.
Q5. In an ER diagram, a diamond represents:
A. Entity
B. Attribute
C. Relationship
D. Primary key
Answer: C (Relationship)
Rationale: Rectangles = entities, ellipses = attributes,
diamonds = relationships.
Q6. Which cardinality means one entity instance relates
to many of another, but not vice versa?
A. 1:1
B. 1:M
3
, C. M:N
D. M:1
Answer: B (1:M)
Rationale: One-to-many – e.g., one customer, many
orders.
Q7. A recursive relationship means:
A. Table relates to itself
B. Table relates to two others
C. Table has no primary key
D. Table has composite key
Answer: A (Table relates to itself)
Rationale: Example: Employee supervises other
Employees.
Q8. Which is a weak entity?
A. Has its own primary key
B. Existence depends on another entity
C. Always in 3NF
D. Cannot have attributes
4
