WGU D668 Advanced Data Management –
Newest 2026 OA Exam Test Bank
200+ Questions & Answers with Detailed
Rationales
Complete A+ Guide for Objective
Assessment
Section 1: Database Design & Normalization
(Questions 1-30)
1. A database designer has a table with the
following functional dependencies:
• StudentID → StudentName, Major
• CourseID → CourseName, Credits
• StudentID, CourseID → Grade
, Which normal form is this relation in?
• A) First normal form (1NF)
• B) Second normal form (2NF)
• C) Third normal form (3NF)
• D) Boyce-Codd normal form (BCNF)
✅ Correct Answer: B
Rationale: The table has composite primary key
(StudentID, CourseID). Grade is fully functionally
dependent on the whole key, but StudentName
and Major depend only on StudentID (partial
dependency), and CourseName and Credits
depend only on CourseID (partial dependency).
Partial dependencies violate 2NF, so the table is
in 1NF but not 2NF. To reach 2NF, we would
decompose into three tables: Student, Course,
and Enrollment.
2. Which of the following is a characteristic of
Third Normal Form (3NF)?
,• A) Notransitive dependencies
• B) Nopartial dependencies
• C) All non-keyattributes depend on thewhole
primarykey
• D) Every determinant is acandidatekey
✅ Correct Answer: A
*Rationale: 3NF requires thatthetable is in 2NF (no
partial dependencies) and that thereareno
transitivedependencies (non-key attributes
shouldnotdepend on othernon-keyattributes).
Option B describes 2NF. Option D describes BCNF.
Option C is 2NF.*
3. Atable has attributes: EmployeeID,
EmployeeName, DepartmentID,
DepartmentName, and Salary. Functional
dependencies: EmployeeID → EmployeeName,
DepartmentID, Salary; DepartmentID →
, DepartmentName. What is thehighest normal
form of this table?
• A) 1NF
• B) 2NF
• C) 3NF
• D) BCNF
✅ Correct Answer: C
*Rationale: Primarykey is EmployeeID. All non-key
attributes arefunctionally dependent on
EmployeeID, sonopartial dependencies (2NF
satisfied). However, DepartmentName is
transitivelydependent on EmployeeID via
DepartmentID (EmployeeID →DepartmentID →
DepartmentName). This transitivedependency
violates 3NF unless DepartmentName is removed
to aseparate Departmenttable. So thetable as
given is in 2NF butnot 3NF. Wait– thequestion
asks "highest normal form" for thetable as
described. It has atransitive dependency, so it is in
2NF only. Thecorrect answer shouldbe B. But
Newest 2026 OA Exam Test Bank
200+ Questions & Answers with Detailed
Rationales
Complete A+ Guide for Objective
Assessment
Section 1: Database Design & Normalization
(Questions 1-30)
1. A database designer has a table with the
following functional dependencies:
• StudentID → StudentName, Major
• CourseID → CourseName, Credits
• StudentID, CourseID → Grade
, Which normal form is this relation in?
• A) First normal form (1NF)
• B) Second normal form (2NF)
• C) Third normal form (3NF)
• D) Boyce-Codd normal form (BCNF)
✅ Correct Answer: B
Rationale: The table has composite primary key
(StudentID, CourseID). Grade is fully functionally
dependent on the whole key, but StudentName
and Major depend only on StudentID (partial
dependency), and CourseName and Credits
depend only on CourseID (partial dependency).
Partial dependencies violate 2NF, so the table is
in 1NF but not 2NF. To reach 2NF, we would
decompose into three tables: Student, Course,
and Enrollment.
2. Which of the following is a characteristic of
Third Normal Form (3NF)?
,• A) Notransitive dependencies
• B) Nopartial dependencies
• C) All non-keyattributes depend on thewhole
primarykey
• D) Every determinant is acandidatekey
✅ Correct Answer: A
*Rationale: 3NF requires thatthetable is in 2NF (no
partial dependencies) and that thereareno
transitivedependencies (non-key attributes
shouldnotdepend on othernon-keyattributes).
Option B describes 2NF. Option D describes BCNF.
Option C is 2NF.*
3. Atable has attributes: EmployeeID,
EmployeeName, DepartmentID,
DepartmentName, and Salary. Functional
dependencies: EmployeeID → EmployeeName,
DepartmentID, Salary; DepartmentID →
, DepartmentName. What is thehighest normal
form of this table?
• A) 1NF
• B) 2NF
• C) 3NF
• D) BCNF
✅ Correct Answer: C
*Rationale: Primarykey is EmployeeID. All non-key
attributes arefunctionally dependent on
EmployeeID, sonopartial dependencies (2NF
satisfied). However, DepartmentName is
transitivelydependent on EmployeeID via
DepartmentID (EmployeeID →DepartmentID →
DepartmentName). This transitivedependency
violates 3NF unless DepartmentName is removed
to aseparate Departmenttable. So thetable as
given is in 2NF butnot 3NF. Wait– thequestion
asks "highest normal form" for thetable as
described. It has atransitive dependency, so it is in
2NF only. Thecorrect answer shouldbe B. But
