View the Exhibit and examine the data in EMPLOYEES and DEPARTMENTS tables.

View the Exhibit and examine the data in EMPLOYEES and
DEPARTMENTS tables. In the EMPLOYEES table EMPLOYEE_ID is the PRIMARY
KEY and DEPARTMENT_ID is the FOREIGN KEY. In the DEPARTMENTS table
DEPARTMENT_ID is the PRIMARY KEY.
Evaluate the following UPDATE statement:
UPDATE employees a
SET department_jd =
(SELECT department_id
FROM departments
WHERE location_id = ‘2100’),
(salary, commission_pct) =
(SELECT 1.1*AVG(salary), 1.5*AVG(commission_pct)
FROM employees b
WHERE

A.
department_jd = b. department_id)
WHERE first_name|| ‘||last_name = ‘Amit Banda’;
What would be the outcome of the above statement?
It would execute successfully and update the relevant data.

A.
department_jd = b. department_id)
WHERE first_name|| ‘||last_name = ‘Amit Banda’;
What would be the outcome of the above statement?
It would execute successfully and update the relevant data.

B.
It would not execute successfully because there is no LOCATION_ID 2100 in the
DEPARTMENTS table.

C.
It would not execute successfully because the condition specified with the
concatenation operator is not valid.

D.
It would not execute successfully because multiple columns (SALARY
,COMMISSION_PCT)cannot be used in an UPDATE statement.