A Query Includes the DeptID and DeptName Fields from the Departments

question 33

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.

---

Definitions:

Broker Commission

A fee paid to a broker for executing a transaction or providing specialized services.

Temporary Investments

Investments in securities that are expected to be sold within a short period, typically within one year.

Current Assets

Assets that are expected to be converted into cash, sold, or consumed within one year or within the operating cycle of the business, whichever is longer.

Cash Equivalents

Investments that are liquid and short-term, easily turned into a specific amount of cash, with their initial durations being three months or shorter.