QUESTION 49You have a row level BEFORE UPDATE trigger on the EMP table. This trigger contains a SELECT statement on the EMP table to ensure that the new salary value falls within the minimum and maximum salary for a given job title.What happens when you try to update a salary value in the EMP table?
(A)The trigger fires successfully.
(B)The trigger fails because it needs to be a row level AFTER UPDATE trigger.
(C)The trigger fails because a SELECT statement on the table being updated is not allowed.
(D)The trigger fails because you cannot use the minimum and maximum functions in a BEFORE UPDATE trigger.