問題詳情

QUESTION 39Examine this code:CREATE OR REPLACE PROCEDURE audit_action(p_who VARCHAR2)ASBEGININSERT INTO audit(schema_user) VALUES(p_who);END audit_action;/CREATE OR REPLACE TRIGGER watch_itAFTER LOGON ON DATABASECALL 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.

參考答案

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