Oracle
1Z0-147 · Question #20
1Z0-147 Question #20: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-147 to reveal the answer and full explanation for question #20. The question stem and answer options stay visible for context.
Question
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?
Options
- AThe trigger records an audit trail when a user makes changes to the database.
- BThe trigger marks the user as logged on to the database before an audit statement is issued.
- CThe trigger invokes the procedure audit_action each time a user logs on to his/her schema and adds the username to the audit table.
- DThe trigger invokes the procedure audit_action each time a user logs on to the database and adds the username to the audit table.
Unlock 1Z0-147 to see the answer
You've previewed enough free 1Z0-147 questions. Unlock 1Z0-147 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.