Oracle 1Z0-101 Exam Details & Actual Exam Questions

Oracle Develop pl/sql program units Exam Questions

(32 Up Votes)

Certification Vendor:	Oracle
Exam Name:	Develop PL/SQL Program Units
Exam Number:	1Z0-101
Exam Format:	Multiple Choice
Available Languages:	English
Related Certifications:	Oracle Certified Professional (OCP) Internet Application Developer
Sample Questions:	Oracle 1Z0-101 Sample Questions
Exam Way:	Oracle Authorized Testing Center (onsite); historical exam that is no longer actively offered.
Pre Condition:	Historically part of the Oracle Certified Professional Internet Application Developer certification track; candidates typically completed Oracle SQL and PL/SQL prerequisite exams as defined by Oracle at the time.
Official Syllabus URL:	https://education.oracle.com/

Section	Objectives
Triggers	- Database Triggers 1. Row-level and statement-level triggers 2. Create DML triggers 3. INSTEAD OF triggers 4. BEFORE and AFTER triggers
Exception Handling	- Exceptions 1. RAISE and RAISE_APPLICATION_ERROR 2. Predefined exceptions 3. User-defined exceptions 4. Exception propagation and handling
Dynamic SQL and Advanced PL/SQL Features	- Advanced Programming 1. Use Oracle supplied packages 2. Implement secure and reusable PL/SQL code 3. Use dynamic SQL
Packages	- Package Development 1. Create package bodies 2. Public and private program elements 3. Package variables and initialization 4. Create package specifications
Creating and Managing Procedures and Functions	- Procedures 1. Create and modify procedures 2. Use parameters and parameter modes 3. Invoke procedures - Functions 1. Create and modify functions 2. Return values from functions 3. Use functions in SQL and PL/SQL expressions
Dependencies and Program Unit Management	- Program Unit Administration 1. Manage dependencies 2. Use data dictionary views for PL/SQL objects 3. Compile and recompile program units
Cursors and SQL Processing	- Cursor Management 1. Explicit cursors 2. Cursor FOR loops 3. Cursor attributes 4. Cursor parameters