On October 19th 2019, Skillsoft Cloud Operations will be conducting maintenance activities on the infrastructure and software supporting the US Skillport, Skillport w/Compliance, OLSA, Publisher systems. As a result, these services will be inaccessible during this maintenance event. Every effort is being made to minimize the duration of those activities, and our expectation is that the impact will not exceed 12 hours commencing at 7:00 am ET.
Save 25% to celebrate Cybersecurity Awareness Month! Learn More »

1Z0-144Oracle Database 11g: Program with PL/SQL (OCP)

Candidates for the Oracle Database 11g: Program with PL/SQL (OCP) exam are application developers, database administrators, system analysts, forms developers, technical consultants, portal developers, and PL/SQL developers with previous programming experience and the prerequisites of Oracle Database: Introduction to SQL, Oracle Database: SQL Workshop II Ed 2, and Oracle Database: SQL Workshop I Ed 2.

This exam measures the following skills*:

  • Manage dependencies between PL/SQL subprograms
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Create stored procedures and functions
  • Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
  • Use the Oracle supplied PL/SQL packages to generate screen output, file output, and mail output
  • Write dynamic SQL for more coding flexibility
  • Create overloaded package subprograms for more flexibility
  • Create triggers to solve business challenges
  • Create and debug stored procedures and functions
  • Describe the features and syntax of PL/SQL
  • Design PL/SQL anonymous blocks that execute efficiently
  • Design PL/SQL packages to group related constructs
  • Handle runtime errors

For more information about the 1Z0-144 exam, visit the Oracle site.

*These exam objectives can change at any time.

1Z0-144 Oracle Database 11g: Program with PL/SQL (OCP) Certification Study Package

Kaplan IT Training Certification Packages are based on Kaplan's proven learning strategy of Prepare, Practice, Perform® and are customizable to fit your preferred study method. Study at your own pace, whenever you want, and wherever you are most comfortable. Choose between our 30-Day Assessment and 180-Day Exam Preparation. Practice with exam-like questions. 

30-Day Assessment (Online only)

  • A single set of focused exam-like questions
  • Custom quiz settings to drill down into specific topics
  • Detailed explanations and references
  • Grade as you go or simulate the exam experience
  • Online access only
  • Upgrade to the 180-Day Exam Preparation for only $40

180-Day Exam Preparation (Online + Download)

  • Multiple unique sets of exam-like questions for additional exam experiences
  • Custom quiz settings to drill down into specific topics
  • Detailed explanations and references
  • Grade as you go or simulate the exam experience
  • Performance Tracker to see how your performance stacks up to others
  • Full set of key concepts flashcards to memorize critical information
  • Online access and downloadable and printable quizzes for offline study
  • Study Calendar to optimize your exam study time
  • InstructorLink™ to contact our IT experts
  • Pass Guarantee to ensure your success

Build Your Package:

Kaplan IT Training Certification Package Grid Image