QUESTION 79You have the following table:CREATE TABLE Emp_log (Emp_id NUMBERLog_date DATE,New_salary NUMBER,Action VARCHAR (20));You have the following data in the EMPLOYEES table:EMPLOYEE_ID LAST_NAME SALARY DEPARTMENT_ID----------- ------------------- ------------ ------------- 100 Bill 24000 90101 Kochhar 17000 90102 De Haan 17000 90103 Hunold 9000 60104 Ernst 6000 60105 Austin 4800 60106 Pataballa 4800 60107 Lorentz 4200 60108 Greenberg 12000 100201 Hartstein 13000 20202 Fay 6000 20You create this trigger:CREATE OR REPLACE TRIGGER Log_salary_increaseAFTER UPDATE ON employeesFOR EACH ROWWHEN (new.Salary > 1000)BEGININSERT INTO Emp_log (Emp_id, Log_date, New_Salary, Action) VALUES (:new.Employee_id, SYSDATE, :new.SALary, 'NEW SAL');END/Then, you enter the following SQL statement:UPDATE Employee SET Salary = Salary + 1000.0Where Department_id = 20MWhat are the result in the EMP_LOG table?AEMP_ID LOG_DATE NEW_SALARY ACTION---------- -------- ---------- ----------201 24-SEP-02 13000 NEW SAL202 24-SEP-02 600 NEW SAL
(B)EMP_ID LOG_DATE NEW_SALARY ACTION---------- -------- ---------- ----------201 24-SEP-02 14000 NEW SAL202 24-SEP-02 7000 NEW SAL
(C)EMP_ID LOG_DATE NEW_SALARY ACTION---------- -------- ---------- ----------201 24-SEP-02 NEW SAL202 24-SEP-02 NEW SAL
(D)No rows are inserted.