1Z0-101 Exam Dumps
Oracle Develop pl/sql program units 1Z0-101 real exam questions and online practice test engine by FreeCram. Try 1Z0-101 exam questions for free. You can also download a free demo of the 1Z0-101 exam PDF version.
Oracle's 1Z0-101 actual exam materials brought to you by FreeCram group of Oracle certification experts.
View all 1Z0-101 actual exam questions & answers and explanations for free.
If you like our product, you can request full access to all the latest Oracle Develop pl/sql program units 1Z0-101 exam premium questions.
| Certification Provider: | Oracle |
|---|---|
| Exam Code / Number: | 1Z0-101 |
| Exam Name: | Develop pl/sql program units |
| Exam Questions: | 114 |
| Last Updated: | Jul 28, 2026 |
| Corresponding Certification: | 9i Internet Application Developer |
(354 Up Votes)Oracle 1Z0-101 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Working with PL/SQL Packages | 25% | - Package variables, cursors, and exceptions - Create, compile, and drop packages - Overloading subprograms - Package specification vs package body - Use Oracle-supplied packages |
| Creating and Managing Procedures | 20% | - Calling procedures and handling parameters - Create, modify, and drop procedures - Exception handling in procedures - Parameter modes: IN, OUT, IN OUT |
| Advanced PL/SQL Features | 10% | - Dynamic SQL with EXECUTE IMMEDIATE - Conditional compilation - Code obfuscation and security |
| 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 |
| Creating and Managing Functions | 20% | - Create, modify, and drop functions - Return values and function usage in SQL - Deterministic and parallel-enable functions - Differentiate between procedures and functions |
| Database Triggers | 15% | - Trigger types and timing: BEFORE, AFTER, INSTEAD OF - Row-level vs statement-level triggers - Create, enable, disable, and drop triggers - Trigger restrictions and mutating table issues |