Certification exams change, and study material has to keep up. The 1Z0-147 (Oracle9i program with pl/sql) question bank at Actual4Exams is reviewed continuously and comes with 365 days of free updates, so your 2026 preparation always reflects the current exam.
Oracle 1Z0-147 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle9i Program with PL/SQL |
| Exam Number: | 1Z0-147 |
| Related Certifications: | Oracle PL/SQL Developer Certified Professional |
| Real Exam Qty: | 64 - 66 |
| Passing Score: | 70% - 77% |
| Exam Price: | USD 245 |
| Exam Format: | Multiple Choice, Multiple Answer, Single Answer |
| Available Languages: | English |
| Exam Duration: | 90 minutes |
| Certificate Validity Period: | Lifetime |
| Recommended Training: | Oracle9i: Program with PL/SQL Training |
| Exam Registration: | Oracle University Pearson VUE Oracle Registration |
| Sample Questions: |  |
| Exam Way: | Computer-based test, delivered at authorized Pearson VUE centers; retired after July 31, 2013 |
| Pre Condition: | No mandatory prerequisites; recommended basic knowledge of SQL and Oracle Database 9i |
| Official Syllabus URL: | https://education.oracle.com/ |
Oracle 1Z0-147 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Procedures and Functions | 20% | - Creating and invoking functions
|
| Error Handling and Exceptions | 10% | - Handling exceptions
|
| PL/SQL Fundamentals | 15% | - Overview of PL/SQL
|
| Managing Dependencies and Performance | 5% | - Object dependencies
|
| Database Triggers | 15% | - Trigger concepts
|
| Packages | 20% | - Package structure
|
| Control Structures | 15% | - Iterative statements
|
Common Questions About the Oracle 1Z0-147 Exam
The 1Z0-147 exam, officially known as Oracle9i program with pl/sql, is the Oracle test that leads to the Oracle9i Internet Application Developer certification at the Professional level. Passing it validates the skills employers expect from a certified professional. It is also associated with related credentials such as Oracle PL/SQL Developer Certified Professional.
The 1Z0-147 exam contains 64 - 66 questions, and you have 90 minutes to complete them. Work out your per-question pace before test day, and flag slow items instead of stalling on them — time pressure, not knowledge, sinks many first attempts. Timed mock exams in the Actual4Exams test engines are the most reliable way to build that rhythm.
The passing score for the 1Z0-147 exam is 70% - 77%, and the official registration fee is USD 245. If you miss the mark, a retake means paying the full fee again, so book your seat only when you are ready. A practical benchmark: score consistently above the passing line on timed practice tests before scheduling the real exam.
No mandatory prerequisites; recommended basic knowledge of SQL and Oracle Database 9i
Entry requirements can change, so confirm the latest conditions on the official exam page: https://education.oracle.com/.
You can book the 1Z0-147 exam through the official registration channels below:
Exam delivery: Computer-based test, delivered at authorized Pearson VUE centers; retired after July 31, 2013. Seats at popular test centers fill quickly, so schedule early once your preparation is on track.
Oracle recommends the following training options for Oracle9i program with pl/sql candidates:
Pair any course with the 111 practice questions from Actual4Exams to measure how ready you really are before paying the exam fee.
Yes. A free PDF demo of the Oracle9i program with pl/sql questions is available, so you can check the question style and answer quality before you pay. Every purchase also includes 365 days of free updates, and if the product expires you can renew the update service at a 50% discount from your member zone.
If you take the corresponding 1Z0-147 exam within 60 days of purchase and do not pass, you can apply for a full refund under the 100% Money Back Guarantee: submit a scan of your enrollment slip and your official Score Report (PDF) within 2 days of the exam date, and the claim is processed within 7 days. Attempts made within 3 days of purchase, downloads without an actual exam attempt, free materials, and expired orders are not eligible, and the candidate name must match the payer name. Prefer new material instead of a refund? You can exchange your purchase for two free products of equal value and keep the update service on your original product. As for delivery, the files are available for instant download and are also emailed to you within one minute of payment — if nothing arrives within 2 hours, contact customer service. There is no limit on how many computers you can install the product on.
The official Oracle9i program with pl/sql outline is organized into 7 domains. The first three are:
- Database Triggers — 15% of the exam
- Packages — 20% of the exam
- Control Structures — 15% of the exam
See the complete exam topics section above for the full outline and the weighting of every domain.
Oracle9i program with pl/sql Sample Questions:
Examine this function:
CREATE OR REPLACE FUNCTION CALC_PLAYER_AVG (V_ID in PLAYER_BAT_STAT.PLAYER_ID%TYPE) RETURN NUMBER IS V_AVG NUMBER; BEGIN SELECT HITS / AT_BATS INTO V_AVG FROM PLAYER_BAT_STAT WHERE PLAYER_ID = V_ID; RETURN (V_AVG); END; Which statement will successfully invoke this function in SQL *Plus?
- A. EXECUTE CALC_PLAYER_AVG(31);
- B. CALC_PLAYER('RUTH');
- C. CALC_PLAYER_AVG(31);
- D. SELECT CALC_PLAYER_AVG(PLAYER_ID) FROM PLAYER_BAT_STAT;
- E. START CALC_PLAYER_AVG(31)
Explanation: Only visible for Actual4Exams members. You can sign-up / login (it's free).
Examine this procedure:
CREATE OR REPLACE PROCEDURE ADD_PLAYER
(V_ID IN NUMBER, V_LAST_NAME VARCHAR2)
IS
BEGIN
INSERT INTO PLAYER (ID,LAST_NAME)
VALUES (V_ID, V_LAST_NAME);
COMMIT;
END;
This procedure must invoke the APD_BAT_STAT procedure and pass a parameter.
Which statement, when added to the above procedure will successfully invoke the
UPD_BAT_STAT procedure?
- A. RUN UPD_BAT_STAT(V_ID);
- B. START UPD_BAT_STAT(V_ID);
- C. UPD_BAT_STAT(V_ID);
- D. EXECUTE UPD_BAT_STAT(V_ID);
Explanation: Only visible for Actual4Exams members. You can sign-up / login (it's free).
Examine this code:
CREATE OR REPLACE PROCEDURE add_dept
( p_name departments.department_name%TYPE DEFAULT 'unknown',
p_loc departments.location_id%TYPE DEFAULT 1700)
IS
BEGIN
INSERT INTO departments(department_id, department_name,
loclation_id)
VALUES(dept_seq.NEXTVAL,p_name, p_loc);
END add_dept;
/
You created the add_dept procedure above, and you now invoke the procedure in SQL *Plus.
Which four are valid invocations? (Choose four)
- A. EXECUTE add_dept(p_name=>'Education', 2500)
- B. EXECUTE add_dept('2500', p_loc =>2500)
- C. EXECUTE add_dept(p_loc=>2500)
- D. EXECUTE add_dept('Education', 2500)
- E. EXECUTE add_dept(p_loc=>2500, p_name=>'Education')
Explanation: Only visible for Actual4Exams members. You can sign-up / login (it's free).
Examine this procedure:
CREATE OR REPLACE PROCEDURE INSERT_TEAM
(V_ID in NUMBER, V_CITY in VARCHAR2 DEFAULT 'AUSTIN', V_NAME in VARCHAR2)
IS
BEGIN
INSERT INTO TEAM (id, city, name)
VALUES (v_id, v_city, v_name);
COMMIT;
END
Which two statements will successfully invoke this procedure in SQL *Plus? (Choose two)
- A. EXECUTE INSERT_TEAM (V_ID := V_NAME := 'LONGHORNS', V_CITY := 'AUSTIN');
- B. EXECUTE INSERT_TEAM;
- C. EXECUTE INSERT_TEAM (3, 'LONGHORNS');
- D. EXECUTE INSERT_TEAM(3, 'AUSTIN','LONGHORNS');
- E. EXECUTE INSERT_TEAM(3, V_NAME=>'LONGHORNS', V_CITY=>'AUSTIN');
Explanation: Only visible for Actual4Exams members. You can sign-up / login (it's free).
All users currently have the INSERT privilege on the PLAYER table. You only want your users to insert into this table using the ADD_PLAYTER procedure. Which two actions must you take? (Choose two)
- A. GRANT INSERT ON PLAYER TO PUBLIC;
- B. GRANT EXECUTE,INSERT ON ADD_PLAYER TO PUBLIC;
- C. GRANT SELECT ON ADD_PLAYER TO PUBLIC;
- D. REVOKE INSERT ON PLAYER FROM PUBLIC;
- E. GRANT EXECUTE ON ADD_PLAYER TO PUBLIC;
Explanation: Only visible for Actual4Exams members. You can sign-up / login (it's free).
No help, Full refund!
Actual4Exams confidently stands behind all its offerings by giving Unconditional "No help, Full refund" Guarantee. Since the time our operations started we have never seen people report failure in the Oracle 1Z0-147 exam after using our products. With this feedback we can assure you of the benefits that you will get from our products and the high probability of clearing the 1Z0-147 exam.
We still understand the effort, time, and money you will invest in preparing for your certification exam, which makes failure in the Oracle 1Z0-147 exam really painful and disappointing. Although we cannot reduce your pain and disappointment but we can certainly share with you the financial loss.
This means that if due to any reason you are not able to pass the 1Z0-147 actual exam even after using our product, we will reimburse the full amount you spent on our products. you just need to mail us your score report along with your account information to address listed below within 7 days after your unqualified certificate came out.
