1Z0-147: Program with PL/SQL was a foundational certification exam offered by Oracle Corporation that validated a developer’s proficiency in building database applications using PL/SQL (Procedural Language/Structured Query Language). Originally introduced during the Oracle9i and Oracle Database 10g eras, it served as a core requirement for earning the Oracle Certified Associate (OCA) PL/SQL Developer track credential. ⚠️ Critical Update: Retirement Status
The 1Z0-147 exam has been officially retired by Oracle Education. You can no longer register for or take this specific test. It has been replaced by modernized certification paths designed for current database architectures. If you are seeking a PL/SQL certification, you must take:
Current Replacement: Oracle Database Program with PL/SQL | Exam 1Z0-149, which validates skills on modern releases like Oracle Database 19c.
Current SQL Prerequisite: To achieve the full Oracle Database PL/SQL Developer Certified Professional credential, you must also pass a core SQL exam, such as Oracle Database SQL | Exam 1Z0-071. What the 1Z0-147 Exam Covered
Historically, the exam tested a candidate’s ability to write server-side PL/SQL blocks, procedures, functions, packages, and database triggers. The core programmatic topics included: 1Z0-147, Program With PL/SQL: Oracle Certification Prep
Leave a Reply