Which of the following is the SQL query to generate a trigger whenever an employee’s salary is greater than the salary of his or her direct supervisor in the company and to execute the procedure stored in INFORM_SUPERVISOR?
1
CREATE TRIGGER SALARY_VIOLATION
ON INSERT OR UPDATE OF SALARY, SUPERVISOR_SSN
ON EMPLOYEE
FOR EACH ROW
WHEN (NEW.SALARY > (SELECT SALARY FROM EMPLOYEE
WHERE SSN = NEW.SUPERVISOR_SSN ))
INFORM_SUPERVISOR(NEW.Supervisor_ssn, NEW.Ssn);
2
CREATE TRIGGER SALARY_VIOLATION
BEFORE INSERT AND UPDATE OF SALARY, SUPERVISOR_SSN
ON EMPLOYEE
FOR EACH ROW
WHEN (NEW.SALARY > (SELECT SALARY FROM EMPLOYEE
WHERE SSN = NEW.SUPERVISOR_SSN ))
INFORM_SUPERVISOR(NEW.Supervisor_ssn, NEW.Ssn);
3
CREATE TRIGGER SALARY_VIOLATION
BEFORE INSERT OR UPDATE OF SALARY, SUPERVISOR_SSN
ON EMPLOYEE
FOR EACH ROW
WHEN (NEW.SALARY < (SELECT SALARY FROM EMPLOYEE
WHERE SSN = NEW.SUPERVISOR_SSN ))
INFORM_SUPERVISOR(NEW.Supervisor_ssn, NEW.Ssn);
4
CREATE TRIGGER SALARY_VIOLATION
BEFORE INSERT OR UPDATE OF SALARY, SUPERVISOR_SSN
ON EMPLOYEE
FOR EACH ROW
WHEN (NEW.SALARY > (SELECT SALARY FROM EMPLOYEE
WHERE SSN = NEW.SUPERVISOR_SSN ))
INFORM_SUPERVISOR(NEW.Supervisor_ssn, NEW.Ssn);
5
Question Not Attempted