We're so confident of our products that we provide no hassle product exchange.
Oracle 1Z0-101 Exam Overview:
| Certification Vendor: | Oracle |
|---|---|
| Exam Name: | Develop PL/SQL Program Units |
| Exam Number: | 1Z0-101 |
| Available Languages: | English |
| Exam Price: | $195 USD |
| Related Certifications: | Oracle 9i PL/SQL Developer Certified Associate Oracle 9i Application Developer Certified Professional |
| Certificate Validity Period: | Retired / No longer valid |
| Passing Score: | 63% |
| Real Exam Qty: | 60 |
| Exam Format: | Multiple Choice, Single Answer, Multiple Response |
| Exam Duration: | 90 minutes |
| Recommended Training: | Oracle Database: Develop PL/SQL Program Units |
| Exam Registration: | Pearson VUE (Historical) |
| Sample Questions: | Oracle 1Z0-101 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 |
|---|---|---|
| Topic 1: Creating and Managing Procedures | 20% | - Exception handling in procedures - Calling procedures and handling parameters - Parameter modes: IN, OUT, IN OUT - Create, modify, and drop procedures |
| Topic 2: Advanced PL/SQL Features | 10% | - Code obfuscation and security - Conditional compilation - Dynamic SQL with EXECUTE IMMEDIATE |
| Topic 3: Creating and Managing Functions | 20% | - Return values and function usage in SQL - Differentiate between procedures and functions - Create, modify, and drop functions - Deterministic and parallel-enable functions |
| Topic 4: Introduction to PL/SQL Program Units | 10% | - PL/SQL compilation and dependency management - Benefits of stored program units - Overview of PL/SQL blocks and subprograms |
| Topic 5: Database Triggers | 15% | - Row-level vs statement-level triggers - Trigger types and timing: BEFORE, AFTER, INSTEAD OF - Trigger restrictions and mutating table issues - Create, enable, disable, and drop triggers |
| Topic 6: Working with PL/SQL Packages | 25% | - Overloading subprograms - Package variables, cursors, and exceptions - Package specification vs package body - Create, compile, and drop packages - Use Oracle-supplied packages |
By Peter
