Examine this code:

CREATE OR REPLACE TRIGGER secure_emp
BEFORE LOGON ON employees
BEGIN
IF (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 may
insert into the EMPLOYEES table only during
business hours.');
END IF;
END;
/

What type of trigger is it?

Question

Examine this code:

CREATE OR REPLACE TRIGGER secure_emp
BEFORE LOGON ON employees
BEGIN
 IF (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 may
 insert into the EMPLOYEES table only during
 business hours.');
 END IF;
END;
/

What type of trigger is it?

Accepted Answer

E. This is an invalid trigger.

Answer

A. DML trigger

Answer

B. INSTEAD OF trigger

Answer

C. application trigger

Answer

D. system event trigger

Examine this code: CREATE OR REPLACE TRIGGER secure_emp BEFORE LOGON ON employees BEGIN IF (TO_CHAR(SYSDATE, 'DY') IN ('SAT', 'SUN')) OR (TO_CHAR(SYSDATE, 'HH24:MI') NOT BETWEEN '08:00' AND '18:00')…

Question

Options

How the community answered

Community Discussion