問題詳情

QUESTION 73Examine the trigger heading:CREATE OR REPLACE TRIGGER salary_checkBEFORE UPDATE OF sal, job ON empFOR EACH ROWUnder which condition does this trigger fire?
(A)When a row is inserted into the EMP table.
(B)When the value of the SAL or JOB column in a row is updated in the EMP table.
(C)When any column other than the SAL and JOB columns in a row are updated in the EMP table.
(D)Only when both values of the SAL and JOB columns in a row are updated together in the EMP table.

參考答案

答案:B
難度:非常困難0
統計:A(0),B(0),C(0),D(0),E(0)