Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: meters are not needed since the procedure has default values defined for each formal parameter. The EXECUTE or EXEC statement is used to invoke an independent procedure from SQL*Plus. The EXECUTE or EXEC keyword is followed by the name of the procedure and arguments. B. This is the correct syntax for invoking this function using positional notation. Incorrect Answers C. This would fail, too many parameters are passed. The procedure being called only has two parameters. D. If this statement was invoked from inside an anonymous PL/SQL Block or from another procedure you would omit the EXECUTE. E. Run is not a valid command for invoking a procedure. QUESTION 49: 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 Actualtests.com - The Power of Knowing 1Z0-147 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. Answer: D Explanation: This trigger fires after a user connects to a database and inserts a record into the audit table. Incorrect Answers A. This Trigger is not defined as a DML Trigger B. This does not make any sense C. If you specified to AFTER LOGON ON SCHEMA this would be the correct answer. QUESTION 50: Which view displays indirect dependencies, indenting each dependency? A. DEPTREE B. IDEPTREE C. INDENT_TREE D. I_DEPT_TREE Answer: B Explanation: The IDEPTREE displays the indirect dependencies with indentation. No indent is used on the first line for the object being analyzed; a sin...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online