Exam Name Oracle Database 11g - Program with PL/SQL Exam Code 1Z0-144 Exam Price USD $245 (Price may vary by country or by localized currency) Duration 90 minutes Number of Questions 63 Passing Score 65% Format Multiple Choice Questions (MCQ) Oracle 1Z0-144 Syllabus Topics: - Creating Procedures - Differentiate between anonymous blocks and subprograms, use a modularized and layered subprogram design, and identify the benefits of subprograms - Create a simple procedure and invoke it from an anonymous block - Work with procedures - Handle exceptions in procedures, remove a procedure, and display a procedure's information - Creating Functions - Differentiate between a procedure and a function - Describe the uses of functions - Work with functions (create, invoke and remove functions) - Creating Packages - Identify the benefits and the components of packages - Work with packages (create package specification and body, invoke package subprograms, remove a package and display package i