Free Oracle 1Z0-147 Exam Dumps Questions & Answers

Examine this package:
CREATE OR REPLACE PACKAGE discounts
IS
g_id NUMBER := 7829;
discount_rate NUMBER := 0.00;
PROCEDURE display_price (p_price NUMBER);
END discounts;
/
CREATE OR REPLACE PACKAGE BODY discounts
IS
PROCEDURE display_price (p_price NUMBER)
IS
BEGIN
DBMS_OUTPUT.PUT_LINE('Discounted '||
TO_CHAR(p_price*NVL(discount_rate, 1)));
END display_price;
BEGIN
discount_rate := 0.10;
END discounts;
/
Which statement is true?

• A.The value of DISCOUNT_RATE is set to 0.10 when the package is invoked for the first time in a session.
• B.The value of DISCOUNT_RATE always remains 0.00 in a session.
• C.The value of DISCOUNT_RATE is set to 0.10 each time the package is invoked in a session.
• D.The value of DISCOUNT_RATE is set to 1.00 each time the procedure DISPLAY_PRICE is invoked.

Which type of argument passes a value from a procedure to the calling environment?

• A.VARCHAR2
• B.OUT
• C.BOOLEAN
• D.IN

Local procedure A calls remote procedure B.
Procedure B was compiled at 8 A.M.
Procedure A was modified and recompiled at 9 A.M. Remote procedure B was later modified and recompiled at 11 A.M.
The dependency mode is set to TIMESTAMP.
What happens when procedure A is invoked at 1 P.M?

• A.Procedure A is invalidated and recompiles for the second time it is invoked.
• B.Procedure B is invalidated and recompiles when invoked.
• C.Procedure A is invalidated and recompiles for the first time it is invoked.
• D.There is no affect on procedure A and it runs successfully.

Examine the code examples. Which one is correct?

• A.CREATE OR REPLACE TRIGGER authorize_action BEFORE INSERT ON EMPLOYEES CALL log_execution; /
• B.CREATE OR REPLACE TRIGGER authorize_action BEFORE EMPLOYEES INSERT CALL log_execution;
• C.CREATE OR REPLACE TRIGGER authorize_action CALL log_execution BEFORE INSERT ON EMPLOYEES; /
• D.CREATE OR REPLACE TRIGGER authorize_action BEFORE EMPLOYEES INSERT CALL log_execution;

You create a DML trigger. For the timing information, which is valid with a DML trigger?

• A.ON SHUTDOWN
• B.DURING
• C.BEFORE
• D.INSTEAD
• E.ON STATEMENT EXECUTION