Free 1Z0-147 Questions for Oracle9i program with pl/sql 1Z0-147 Exam as PDF & Practice Test Engine

Which three are valid ways to minimize dependency failure? (Choose three)

Which two dictionary views track dependencies? (Choose two)

What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?

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?

Which two statements about the overloading feature of packages are true? (Choose two)

Examine this code:
CREATE OR REPLACE TRIGGER secure_emp BEFORE LOGON ON employees BEGIN IF (TO_CHAR(SYSDATE, 'DY') IN ('SAT', 'SUN')) OR (TO_CHAR(SYSDATE, 'HH24:MI') NOT BETWEEN '08:00' AND '18:00') THEN RAISE_APPLICATION_ERROR (-20500, 'You may insert into the EMPLOYEES table only during business hours.'); END IF; END; / What type of trigger is it?

Examine this code
CREATE OR REPLACE PROCEDURE load bfile (p_flle_loc IN VARCHAR2)
IS
V_file BFILE;
V_filename VARCHAR2 (16);
CURSOR emp_cursor IS
SELECT employee_id
FROM employees
WHERE Job_id = 'IT_PROG'
FOR UPDATE;
BEGIN
FOR emp_record IN emp_cursor LOOP
V_filename:= emp_record.employee_id || '.GIF';
V_file := BFILENAME(p_flle_loc, v_filename);
END LOOP;
END;
/
What does the BFILENAME function do?