問題詳情

QUESTION 10Examine this code:CREATE OR REPLACE TRIGGER secure_empBEFORE LOGON ON employeesBEGINIF (TO_CHAR(SYSDATE, 'DY') IN ('SAT', 'SUN')) OR(TO_CHAR(SYSDATE, 'HH24:MI')NOT BETWEEN '08:00' AND '18:00')THEN RAISE_APPLICATION_ERROR (-20500, 'You mayinsert into the EMPLOYEES table only duringbusiness hours.');END IF;END;/What type of trigger is it? long
(A)DML trigger
(B)INSTEAD OF trigger
(C)Application trigger
(D)System event trigger
(E)This is an invalid trigger.

參考答案

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