A Query Includes the DeptID and DeptName Fields from the Departments

Multiple Choice

A query includes the DeptID and DeptName fields from the Departments table and the EmployeeLast field from the Employees table. Both tables are shown below. What must you change before you can reassign the DeptID field value for a particular employee in the query results? Departments (DeptID, DeptName)
Employees (EmpID, EmployeeFirst, EmployeeLast, DeptID)

A) Set DeptID as the primary key field in the Employees table.
B) Add the DeptName field to the query.
C) Remove the EmpID field from the query.
D) Replace the DeptID field from the Departments table with the DeptID field from the Employees table.