試題詳解

QUESTION 49 You 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.