In 2026, a stale question bank is a liability. Test4Cram includes 365 days of free updates with every 1Z0-147 purchase and notifies you the moment a new version is released, so your Oracle9i program with pl/sql prep never falls behind the exam.
Oracle 1Z0-147 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Oracle9i Program with PL/SQL |
| Exam Number: | 1Z0-147 |
| Exam Format: | Multiple Choice, Multiple Response |
| Passing Score: | 65%-70% (varies by exam version) |
| Related Certifications: | Oracle PL/SQL Developer Oracle9i Database Administrator |
| Exam Duration: | 90-120 |
| Exam Price: | $125–$245 USD (varies by region and time) |
| Certificate Validity Period: | No expiration (legacy certification) |
| Available Languages: | English |
| Real Exam Qty: | 40-60 (varies by exam version) |
| Recommended Training: | Oracle University PL/SQL Training |
| Exam Registration: | Pearson VUE Oracle Exams Oracle Certification Registration |
| Sample Questions: |  |
| Exam Way: | Computer-based exam delivered via Pearson VUE (online proctored or test center). |
| Pre Condition: | Basic understanding of SQL and relational database concepts is recommended; no formal prerequisite required. |
| Official Syllabus URL: | https://education.oracle.com/ |
Oracle 1Z0-147 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Cursors | - Cursor FOR loops - Implicit and explicit cursors |
| Topic 2: SQL Fundamentals | - Joins and set operations - Basic SELECT statements and filtering |
| Topic 3: Packages | - Advantages of packages - Package specification and body |
| Topic 4: PL/SQL Fundamentals | - PL/SQL block structure - Variables and data types |
| Topic 5: Advanced PL/SQL Features | - Records and complex data types - Collections (associative arrays, nested tables) |
| Topic 6: Stored Procedures and Functions | - Creation and execution - Parameters and return values |
| Topic 7: Triggers | - Trigger timing and events - DML triggers |
| Topic 8: Control Structures | - Conditional statements (IF, CASE) - Loops (FOR, WHILE, LOOP) |
| Topic 9: Exception Handling | - Predefined exceptions - User-defined exceptions |
1Z0-147 Exam Essentials: Format, Topics, and Policies
The current exam information lists 40-60 (varies by exam version) questions for the 1Z0-147 exam, with 90-120 minutes allowed. Practicing against the clock at home builds the pacing habits that exam day rewards.
The Oracle9i program with pl/sql blueprint covers these main domains:
- Triggers
- Control Structures
- Stored Procedures and Functions
Additional domains complete the official outline, and our bank covers the full range.
You can register through these official channels:
Book early for the best choice of dates and locations — and double-check your spam folder for the confirmation email.
Your money is protected by clear conditions. If you fail the corresponding exam within 60 days of purchase, send us a scanned copy of your enrollment slip and your official Score Report PDF within two days of the exam date; verified claims receive a full refund within seven days. The exclusions: exams taken within three days of purchase, a candidate name that does not match the payer, and free or expired products. If you prefer, we can exchange your product for two others of equal value instead.
Oracle lists the following prerequisites for the Oracle9i program with pl/sql: Basic understanding of SQL and relational database concepts is recommended; no formal prerequisite required..
Check the official certification page for the latest requirements before booking.
Because we remove the guesswork at every step. The 1Z0-147 bank consolidates the Oracle9i program with pl/sql knowledge points into expert-verified Q&As instead of leaving you to sift through the internet alone. A free demo shows the quality before you buy; instant delivery starts you the minute you do; 365 days of free updates — with a notification each time a new version releases — keep you current; and a strict information safety system plus a 7/24 golden-standard support team protect you throughout.
Oracle recommends the following official training options:
Structured coursework plus regular question practice is the combination most candidates find effective.
As of the latest information, the 1Z0-147 exam requires a score of 65%-70% (varies by exam version) to pass, and registration costs $125–$245 USD (varies by region and time). Oracle sets both figures, so verify them on the official site when you book.
Upon successful payment, our system automatically emails the product to your mailbox and shows an instant download link — delivery typically takes about a minute. If nothing arrives within two hours, check your spam folder first, then contact our 7/24 support team. Installations are unlimited. Your purchase also includes 365 days of free updates: whenever we release a new version, we notify you to download it — no need to wait or worry about validity — and a 50% renewal discount applies when the period ends.
Oracle9i program with pl/sql Sample Questions:
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 first time it is invoked.
- B. There is no affect on procedure A and it runs successfully.
- C. Procedure A is invalidated and recompiles for the second time it is invoked.
- D. Procedure B is invalidated and recompiles when invoked.
Correct Answer: C 🗳️
Explanation: Only visible for Test4Cram members. You can sign-up / login (it's free).
Examine this code:
CREATE OR REPLACE TRIGGER update_emp
AFTER UPDATE ON emp
BEGIN
INSERT INTO audit_table (who, dated)
VALUES (USER, SYSDATE);
END;
You issue an UPDATE command in the EMP table that results in changing 10 rows.
How many rows are inserted into the AUDIT_TABLE?
- A. None
- B. 10
- C. A value equal to the number of rows in the EMP table.
- D. 1
Correct Answer: D 🗳️
Explanation: Only visible for Test4Cram members. You can sign-up / login (it's free).
When creating stored procedures and functions, which construct allows you to transfer values to and from the calling environment?
- A. Substitution variables
- B. Boolean variables
- C. local variables
- D. arguments
Correct Answer: D 🗳️
Explanation: Only visible for Test4Cram 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('Education', 2500)
- C. EXECUTE add_dept(p_loc=>2500, p_name=>'Education')
- D. EXECUTE add_dept(p_loc=>2500)
- E. EXECUTE add_dept('2500', p_loc =>2500)
Correct Answer: B,C,D,E 🗳️
Explanation: Only visible for Test4Cram members. You can sign-up / login (it's free).
Examine this package:
CREATE OR REPLACE PACKAGE BB_PACK
IS
V_MAX_TEAM_SALARY NUMBER(12,2);
PROCEDURE ADD_PLAYER(V_ID IN NUMBER, V_LAST_NAME VARCHAR2,
V_SALARY_NUMBER;
END BB_PACK;
/
CREATE OR REPLACE PACKAGE BODY BB_PACK
IS
PROCEDURE UPD_PLAYER_STAT
(V_ID IN NUMBER, V_AB IN NUMBER DEFAULT 4, V_HITS IN NUMBER)
IS
BEGIN
UPDATE PLAYER_BAT_STAT
SET AT_BATS = AT_BATS + V_AB,
HITS = HITS + V_HITS
WHERE PLAYER_ID = V_ID)
COMMIT;
END UPD_PLAYER_STAT;
PROCEDURE ADD_PLAYER
(V_ID IN NUMBER, V_LAST_NAME VARCHAR2, V_SALARY NUMBER)
IS
BEGIN
INSERT INTO PLAYER(ID,LAST_NAME,SALARY)
VALUES (V_ID, V_LAST_NAME, V_SALARY);
UPD_PLAYER_STAT(V_ID,0.0);
END ADD_PLAYER;
END BB_PACK;
Which statement will successfully assign $75,000,000 to the V_MAX_TEAM_SALARY variable
from within a stand-alone procedure?
- A. BB_PACK.V_MAX_TEAM_SALARY := 75000000;
- B. This variable cannot be assigned a value from outside the package.
- C. V_MAX_TEAM_SALARY := 7500000;
- D. BB_PACK.ADD_PLAYER.V_MAX_TEAM_SALARY := 75000000;
Correct Answer: A 🗳️
Explanation: Only visible for Test4Cram members. You can sign-up / login (it's free).
Viewing page 1 out of 23 pages.
Viewing questions 1-5 out of 111 questions.
