Study with 1Z0-147 most valid questions & verified answers

Oracle 1Z0-147 Exam Overview:

Oracle 1Z0-147 Exam Syllabus Topics:

Oracle9i program with pl/sql Sample Questions:

Question 1

Examine this code:
CREATE OR REPLACE PACKAGE bonus
IS
g_max_bonus NUMBER := .99;
FUNCTION calc_bonus (p_emp_id NUMBER)
RETURN NUMBER;
FUNCTION calc_salary (p_emp_id NUMBER)
RETURN NUMBER;
END;
/
CREATE OR REPLACE PACKAGE BODY bonus
IS v_salary employees.salary%TYPE; v_bonus employees.commission_pct%TYPE; FUNCTION calc_bonus (p_emp_id NUMBER) RETURN NUMBER IS BEGIN SELECT salary, commission_pct INTO v_salary, v_bonus FROM employees WHERE employee_id = p_emp_id; RETURN v_bonus * v_salary; END calc_bonus FUNCTION calc_salary (p_emp_id NUMBER) RETURN NUMBER IS BEGIN SELECT salary, commission_pct INTO v_salary, v_bonus FROM employees WHERE employees RETURN v_bonus * v_salary + v_salary; END cacl_salary; END bonus; / Which statement is true?

A. You can call the BONUS.CALC_SALARY packaged function form a DELETE command against the EMPLOYEES table.
B. You can call the BONUS.CALC_SALARY packaged function from a SELECT command against the EMPLOYEES table.
C. You can call the BONUS.CALC_SALARY packaged function from an INSERT command against the EMPLOYEES table.
D. You can call the BONUS.CALC_SALARY packaged function from an UPDATE command against the EMPLOYEES table.

Question 2

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. There is no affect on procedure A and it runs successfully.
D. Procedure A is invalidated and recompiles for the first time it is invoked.

Question 3

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

A. BEFORE
B. IN PLACE OF
C. DURING
D. ON SHUTDOWN
E. ON STATEMENT EXECUTION

Question 4

The OLD and NEW qualifiers can be used in which type of trigger?

A. Row level DML trigger
B. Row level system trigger
C. Statement level system trigger
D. Row level application trigger
E. Statement level application trigger
F. Statement level DML trigger

Question 5

Which three are true regarding error propagation? (Choose three)

A. An exception cannot propagate across remote procedure calls.
B. The use of the RAISE; statement in an exception handler reraises the current exception.
C. An exception raised inside an exception handler immediately propagates to the enclosing block.
D. An exception raised inside a declaration immediately propagates to the current block.

Solutions: