The Oracle Develop pl/sql program units exam has a reputation for tripping up even experienced candidates. Working through 114 realistic practice questions from ActualCollection exposes your weak spots before exam day does.
Oracle 1Z0-101 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Develop PL/SQL Program Units |
| Exam Number: | 1Z0-101 |
| Available Languages: | English |
| Exam Duration: | 90 minutes |
| Exam Price: | $195 USD |
| Real Exam Qty: | 60 |
| Certificate Validity Period: | Retired / No longer valid |
| Passing Score: | 63% |
| Exam Format: | Multiple Response, Multiple Choice, Single Answer |
| Related Certifications: | Oracle 9i Application Developer Certified Professional Oracle 9i PL/SQL Developer Certified Associate |
| Recommended Training: | Oracle Database: Develop PL/SQL Program Units |
| Exam Registration: | Pearson VUE (Historical) |
| Sample Questions: |  |
| Exam Way: | Proctored at Pearson VUE test centers; retired, no longer available for registration |
| Pre Condition: | Basic knowledge of SQL and PL/SQL; recommended to have completed Oracle 9i Introduction to SQL (1Z0-007) or equivalent |
| Official Syllabus URL: | https://education.oracle.com/ |
Oracle 1Z0-101 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Advanced PL/SQL Features | 10% | - Dynamic SQL with EXECUTE IMMEDIATE - Code obfuscation and security - Conditional compilation |
| Introduction to PL/SQL Program Units | 10% | - PL/SQL compilation and dependency management - Overview of PL/SQL blocks and subprograms - Benefits of stored program units |
| Creating and Managing Functions | 20% | - Return values and function usage in SQL - Create, modify, and drop functions - Deterministic and parallel-enable functions - Differentiate between procedures and functions |
| Working with PL/SQL Packages | 25% | - Package specification vs package body - Create, compile, and drop packages - Package variables, cursors, and exceptions - Use Oracle-supplied packages - Overloading subprograms |
| Creating and Managing Procedures | 20% | - Calling procedures and handling parameters - Exception handling in procedures - Create, modify, and drop procedures - Parameter modes: IN, OUT, IN OUT |
| Database Triggers | 15% | - Row-level vs statement-level triggers - Trigger restrictions and mutating table issues - Create, enable, disable, and drop triggers - Trigger types and timing: BEFORE, AFTER, INSTEAD OF |
Answers Every 1Z0-101 Candidate Should Read First
The Oracle Develop pl/sql program units exam is the official Oracle test registered under exam code 1Z0-101. Passing it earns you the Oracle 9i Internet Application Developer Certified Professional certification, a credential at the Professional level. It is also linked to the related certifications: Oracle 9i PL/SQL Developer Certified Associate, Oracle 9i Application Developer Certified Professional. Oracle exams are valued because they test job-ready skills, so a passing score here carries real weight on a resume.
The Oracle Develop pl/sql program units exam includes 60 questions to be completed within 90 minutes. Do the pacing math before exam day: with that many items on the clock, you need a steady rhythm and the discipline to flag a hard question and move on instead of stalling. Two or three full timed sessions with the ActualCollection test engine will show you exactly what that pace feels like, so time pressure stops being a factor on the real day.
To pass the Oracle Develop pl/sql program units exam you need 63%, and the official registration fee is $195 USD. A retake is not discounted: a failed attempt means paying the full $195 USD again, so treat your first sitting as the expensive one. A sensible rule is to book your seat only after you are scoring comfortably above the passing mark on the ActualCollection practice tests, not just squeaking past it once.
Basic knowledge of SQL and PL/SQL; recommended to have completed Oracle 9i Introduction to SQL (1Z0-007) or equivalent
Eligibility rules do change from time to time, so confirm the current requirements before you register on the official exam page.
Registration for the Oracle Develop pl/sql program units exam goes through the official channels below.
As for the delivery format, the exam is taken Proctored at Pearson VUE test centers; retired, no longer available for registration.
Oracle points candidates toward the following training options for Oracle Develop pl/sql program units.
Course work builds the foundation; question practice makes it stick. The 114 practice questions in the ActualCollection 1Z0-101 package let you rehearse each topic under exam-style pressure before the real thing.
Yes. ActualCollection offers a free PDF demo of the Oracle Develop pl/sql program units material so you can judge the question quality and format before spending anything. After purchase, your license includes 365 days of free updates, and if you want to keep receiving updates after that period, renewals are available at a 50% discount.
If you take the Oracle Develop pl/sql program units exam within 60 days of your purchase and do not pass, ActualCollection backs you with a 100% money-back guarantee. The claim must match the exam your product covers: attempts taken within 3 days of purchase are not eligible (that is too little preparation time), and neither are downloaded-but-unused products, free materials, or expired orders. The candidate name must match the payer name, and you need to submit a scanned enrollment slip plus the official Score Report PDF within 2 days of the exam; claims are processed within 7 days. Prefer not to refund? You can swap instead and receive two other exam products of equal value for free while keeping the update service on your original purchase.
Delivery itself is instant: your files are downloadable right away and 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 may install the software on.
The official Oracle Develop pl/sql program units syllabus is organized into 6 domains. Key areas include Database Triggers (15%), Introduction to PL/SQL Program Units (10%), and Creating and Managing Procedures (20%). The complete, up-to-date topic list appears in the exam topics section above; work through it line by line and flag anything you cannot yet explain in your own words.
919 Customer Reviews
