QUESTION 39
Examine this code:
CREATE OR REPLACE PROCEDURE audit_action
(p_who VARCHAR2)
AS
BEGIN
INSERT INTO audit(schema_user) VALUES(p_who);
END audit_action;
/
CREATE OR REPLACE TRIGGER watch_it
AFTER LOGON ON DATABASE
CALL audit_action(ora_login_user)
/
What does this trigger do?
(A) The trigger records an audit trail when a user makes changes to the database.
(B) The trigger marks the user as logged on to the database before an audit statement is issued.
(C) The trigger invoked the procedure audit_action each time a user logs on to his/her schema and adds the username to the audit table.
(D) The trigger invokes the procedure audit_action each time a user logs on to the database and adds the username to the audit table.
寫作批改
VIP與詳解卡管理
私人筆記( 0 )