CREATE OR REPLACE TRIGGER logon_trg
AFTER logon ON SCHEMA
BEGIN
INSERT INTO bb_audit_logon
VALUES (USER, SYSDATE);
END;
In the code fragment above, which of the ____ statement represents the system event.
A) logon
B) INSERT
C) SYSDATE
D) AFTER

Question

Quizplus · Accepted Answer

The logon trigger is triggered after a user logs into the schema, making the logon event itself the system event being captured.

CREATE OR REPLACE TRIGGER Logon_trg