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:

Trimmed Mean

Trimmed Mean is a measure of central tendency calculated by removing a specified percentage of the smallest and largest values from a data set before calculating the mean of the remaining data.

Resampling Method

A statistical technique that involves taking repeated samples from observed data, used for estimation or testing hypotheses.

Bootstrap

A statistical method that involves resampling with replacement from a dataset to assess variability in a statistic.

Permutation

A permutation is an arrangement of all or part of a set of objects, with regard to the order of the arrangement.