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:

Mean

The average value of a set of numbers, calculated by dividing the sum of all values by the number of values.

Normal Distribution

An equal-probability distribution around the mean, which shows that instances near the mean happen more frequently than instances far from the mean.

Normal Probability Distribution

A bell-shaped distribution that is symmetric about the mean, showing how random variables are distributed.

Continuous Probability Distribution

A probability distribution that assigns probabilities to a continuum of possible outcomes, often described by a probability density function.