Saved uestion 33 (1.25 points) Sissy A query includes the DeptID and DeptName fields from the Departments table and the
Posted: Sun May 15, 2022 11:52 am
Saved uestion 33 (1.25 points) Sissy 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 happens when you update the DeptName field value for an employee? Departments (DeptID, DeptName) Employees (EmpID, EmployeeFirst, EmployeeLast, DeptID) Comedy family Babyz Avna laddu a) Access changes the DeptID field value in the same record. Family buzzz welche b) The DeptName field value changes for all employees in that department. Srishti Srinivas PPM was join c) Access displays an error message and does not accept the update. Deepika UMD d) The DeptName field value changes for that one employee only. nhle and the EmployeeLast field from the DeptID field value