1Z0-146Oracle Database 11g Advanced PL/SQL (OCP)

Candidates for the Oracle Database 11g Advanced PL/SQL exam demonstrate expertise in building database-centric Internet applications for both Oracle9i and Oracle Database 10g. Oracle Forms Developer Certified Professionals gain greater credibility, a higher level of efficiency, and improved job performance as application developers.

This exam measures the following skills:

  • Oracle11g: Advanced PL/SQL
  • PL/SQL programming concepts: review
  • Designing PL/SQL code
  • Reporting aggregated data using the group functions
  • Working with collections
  • Using advanced interface methods
  • Using the set operators
  • Manipulating data
  • Implementing fine-grained access control for VPD
  • Manipulating large objects
  • Administering SecureFile LOBs
  • Performance and tuning
  • Improving performance with caching
  • Analyzing PL/SQL code
  • Profiling and tracing PL/SQL code
  • Safeguarding your code against SQL injection attacks

 

1Z0-146 Oracle Database 11g Advanced 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)

  • Focused exam-like questions
  • Custom quiz settings
  • Detailed explanations and references
  • Grade as you go or simulate the exam experience

 180-Day Exam Preparation (Online + Download)

  • Full bank of exam-like questions
  • Custom quiz settings
  • Detailed explanations and references
  • Grade as you go or simulate the exam experience
  • Performance Tracker
  • Key concepts flashcards
  • Download or print quizzes and flashcards for offline study
  • Contact our experts with InstructorLink™

Build Your Package: