Oracle 1Z0-147 Exam Information and Actual Questions

Exam Questions: 111
Updated On: Sep 16, 2026

1Z0-147
FREE EXAM DUMPS QUESTIONS & ANSWERS

All the information you need to pass Oracle9i program with pl/sql 1Z0-147 exam and free practice exam verified by ExamDiscuss exam experts.

Certification Vendor:	Oracle
Exam Name:	Oracle9i Program with PL/SQL
Exam Number:	1Z0-147
Exam Duration:	90-120
Available Languages:	English
Real Exam Qty:	40-60 (varies by exam version)
Related Certifications:	Oracle9i Database Administrator Oracle PL/SQL Developer
Certificate Validity Period:	No expiration (legacy certification)
Passing Score:	65%-70% (varies by exam version)
Exam Format:	Multiple Response, Multiple Choice
Exam Price:	$125–$245 USD (varies by region and time)
Recommended Training:	Oracle University PL/SQL Training
Exam Registration:	Pearson VUE Oracle Exams Oracle Certification Registration
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/

Section	Objectives
Packages	- Advantages of packages - Package specification and body
PL/SQL Fundamentals	- Variables and data types - PL/SQL block structure
Triggers	- DML triggers - Trigger timing and events
Control Structures	- Conditional statements (IF, CASE) - Loops (FOR, WHILE, LOOP)
Advanced PL/SQL Features	- Records and complex data types - Collections (associative arrays, nested tables)
SQL Fundamentals	- Basic SELECT statements and filtering - Joins and set operations
Cursors	- Implicit and explicit cursors - Cursor FOR loops
Exception Handling	- Predefined exceptions - User-defined exceptions
Stored Procedures and Functions	- Creation and execution - Parameters and return values