Certification objectives can change, so current preparation matters in 2026. Actual4dump reviews and updates its 1Z0-147 practice questions for Oracle9i program with pl/sql, and every purchase includes 365 days of free updates.

Choose Your 1Z0-147 Study Format

• Printable PDF: prepared by experts, available for instant download, suitable for study anywhere, and supported by 365 days of free updates.
• Desktop Test Engine: installable Windows software with two practice modes, offline access, and an environment that simulates the exam experience.
• Online Test Engine: instant access through major web browsers on Windows, Mac, Android, and iOS, with test history and performance review.

Order Support from Actual4dump

• Security and privacy protection backed by McAfee.
• A free PDF demo is available so you can review the format and quality before purchasing.
• Every purchase includes 365 days of free updates, with renewal available at a 50% discount after expiration.
• Products are delivered by instant download and by email within one minute after payment. Contact customer support if the message does not arrive within two hours.
• There is no restriction on the number of computers where the product can be installed.

Oracle 1Z0-147 Exam Overview:

Oracle 1Z0-147 Exam Syllabus Topics:

Oracle 1Z0-147 Exam Questions Answered

Oracle9i program with pl/sql Sample Questions:

Question 1

Examine this package:
CREATE OR REPLACE PACKAGE manage_emps
IS
tax_rate CONSTANT NUMBER(5,2) := .28;
v_id NUMBER;
PROCEDURE insert_emp (p_deptno NUMBER, p_sal NUMBER);
PROCEDURE delete_emp;
PROCEDURE update_emp;
FUNCTION calc_tax (p_sal NUMBER)
RETURN NUMBER;
END manage_emps;
/
CREATE OR REPLACE PACKAGE BODY manage_emps
IS
PROCEDURE update_sal
(p_raise_amt NUMBER)
IS
BEGIN UPDATE emp SET sal = (sal * p_raise_emt) + sal WHERE empno = v_id; END; PROCEDURE insert_emp (p_deptno NUMBER, p_sal NUMBER) IS BEGIN INSERT INTO emp(empno, deptno, sal) VALYES(v_id, p_depntno, p_sal); END insert_emp; PROCEDURE delete_emp IS BEGIN DELETE FROM emp WHERE empno = v_id; END delete_emp; PROCEDURE update_emp IS v_sal NUMBER(10, 2); v_raise NUMBER(10, 2); BEGIN SELECT sal INTO v_sal FROM emp WHERE empno = v_id; IF v_sal < 500 THEN v_raise := .05; ELSIP v_sal < 1000 THEN v_raise := .07; ELSE v_raise := .04; END IF; update_sal(v_raise); END update_emp; FUNCTION calc_tax (p_sal NUMBER) RETURN NUMBER IS BEGIN RETURN p_sal * tax_rate;
END calc_tax;
END manage_emps;
/
How many public procedures are in the MANAGE_EMPS package?

A. Three
B. Four
C. Two
D. One
E. Five

Question 2

Which two statements about packages are true? (Choose two)

A. You can pass parameters to packages.
B. The contents of packages can be shared by many applications.
C. A package is loaded into memory each time it is invoked.
D. Packages can be nested.
E. You can achieve information hiding by making package constructs private.

Question 3

You want to create a PL/SQL block of code that calculates discounts on customer orders. -This code will be invoked from several places, but only within the program unit ORDERTOTAL. What is the most appropriate location to store the code that calculates the discounts?

A. A standalone procedure on the client machine.
B. A local subprogram defined within the program unit ORDERTOTAL.
C. A block of code in a PL/SQL library.
D. A stored procedure on the server.
E. A block of code in the body of the program unit ORDERTOTAL.

Question 4

You disabled all triggers on the EMPLOYEES table to perform a data load. Now, you need to enable all triggers on the EMPLOYEES table. Which command accomplished this?

A. ALTER TABLE employees ENABLE ALL TRIGGERS;
B. You cannot enable multiple triggers on a table in one command.
C. ALTER TRIGGERS ON TABLE employees ENABLE;
D. ALTER employees ENABLE ALL TRIGGERS;

Question 5

Examine this code:
CREATE OR REPLACE STORED FUNCTION get_sal
(p_raise_amt NUMBER, p_employee_id employees.employee_id%TYPE)
RETURN NUMBER
IS
v_salary NUMBER;
v_raise NUMBER(8,2);
BEGIN
SELECT salary
INTO v_salary
FROM employees
WHERE employee_id = p_employee_id;
v_raise := p_raise_amt * v_salary;
RETURN v_raise;
END;
Which statement is true?

A. This statement creates a stored function named get_sal with a status of invalid.
B. This statement creates a stored function named get_sal.
C. This statement fails.
D. This statement returns a raise amount based on an employee id.
E. This statement creates a stored procedure named get_sal.

Solutions: