Oracle 1Z0-147 Exam Details & Actual Exam Questions
- Exam Code/Number: 1Z0-147
- Exam Name/Title: Oracle9i program with pl/sql
- Certification Provider: Oracle
- Corresponding Certification: 9i Internet Application Developer
- Exam Questions: 111
- Updated On: Aug,25 2026
- Certification Level: Associate
Oracle9i program with pl/sql Exam Questions
View 1Z0-147 actual exam questions, answers and explanations for free.
93% student found the test questions almost same
All the information you need to pass Oracle9i program with pl/sql 1Z0-147 exam and free practice exam verified by EduDump exam experts.
Said the test questions were almost same
Passed the exams with the material
Found the study quides effective and helpful
(30 Up Votes)Oracle 1Z0-147 Exam Overview:
| Certification Vendor: | Oracle |
| Exam Name: | Oracle9i Program with PL/SQL |
| Exam Number: | 1Z0-147 |
| Real Exam Qty: | 40-60 (varies by exam version) |
| Certificate Validity Period: | No expiration (legacy certification) |
| Exam Duration: | 90-120 |
| Exam Format: | Multiple Choice, Multiple Response |
| Passing Score: | 65%-70% (varies by exam version) |
| Exam Price: | $125–$245 USD (varies by region and time) |
| Related Certifications: | Oracle9i Database Administrator Oracle PL/SQL Developer |
| Available Languages: | English |
| Recommended Training: | Oracle University PL/SQL Training |
| Exam Registration: | Oracle Certification Registration Pearson VUE Oracle Exams |
| Sample Questions: | Oracle 1Z0-147 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 |
|---|---|
| Stored Procedures and Functions | - Parameters and return values - Creation and execution |
| Packages | - Package specification and body - Advantages of packages |
| Triggers | - DML triggers - Trigger timing and events |
| Advanced PL/SQL Features | - Collections (associative arrays, nested tables) - Records and complex data types |
| Cursors | - Implicit and explicit cursors - Cursor FOR loops |
| Exception Handling | - User-defined exceptions - Predefined exceptions |
| SQL Fundamentals | - Basic SELECT statements and filtering - Joins and set operations |
| Control Structures | - Conditional statements (IF, CASE) - Loops (FOR, WHILE, LOOP) |
| PL/SQL Fundamentals | - PL/SQL block structure - Variables and data types |
0
0
0
10