Oracle Certification: Program with PL/SQL

  

Overview

The Oracle’s OCA PL/SQL exam is for the developers who develops database-centric Internet applications for Oracle. Where OCA PL/SQL certification helps to expertise in building database-centric Internet applications for both Oracle9i and Oracle Database 10g.It also launches now with oracle database 11g.

Prerequisite Certification For It

The certification requires you to pass one of the following entry level exams:

• 1Z0-007 – Introduction to Oracle9i SQL
• 1Z0-047 – Oracle Database SQL Expert
• 1Z0-051 – Database 11g: SQL Fundamentals                                        

At that time there are two options for giving that exam which have like that:

• 1Z0-144 – Oracle Database 11g: Program with PL/SQL
• 1Z0-147 – Program with PL/SQL

Exam Info :-
Exam Number: 1Z0-144
Duration: 90 minutes
Number of Questions: 80
Passing Score: 65% ( Passing score subject to change.)
Exam Price: Rs 5845 (India)
                      $195 (global)

Exam Objectives : -

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

Detailed Info :-(Download)

View summary as PDF

Some Important Links :-
 ucertify 
Exam Topics
Oracle Database: Program with PL/SQL 

Oracle

Oracle Certification Program Categories

According to  terminology there are basically five categories in which we can divide the whole Oracle certification Program :-

• Oracle Certified Associate
• Oracle Certified Professional
• Oracle Certified Master
• Oracle Certified Expert Program
• Oracle Certified Specialist  

Oracle Certified Associate 

The Oracle Certified Associate (OCA) credential is typically the first step toward achieving the flagship Oracle Certified Professional certification. The OCA credential ensures that the individual is equipped with fundamental skills, providing a strong foundation for supporting Oracle products. An OCA credential is available for several of today's most in-demand technology job roles.

Oracle Certified Professional

The Oracle Certified Professional (OCP) credential is the benchmark of professional skill and technical expertise required to manage, develop, or implement enterprise-wide databases, middleware, or applications. Increasingly, IT managers use the OCP credential to evaluate the qualifications of employees and job candidates.

Oracle Certified Master

The Oracle Certified Master (OCM) credential recognizes the ultimate advanced level of skills, knowledge, and proven ability. These professionals are qualified to answer the most difficult questions and solve the most complex problems

Oracle certified Expert

 The Certified Expert program is a part of Oracle's Certification Program which grants credentials that recognize competency in specific technologies, architectures or domains not currently covered in the path-based Certified Associate and Certified Professional certifications.
Some of the key features of Expert certifications are:

1. Niche oriented – based upon specific products or technologies rather than broad job roles.
2. Credentials are independent of the current OCA, OCP, OCM hierarchy.
3. Typically comprises a single comprehensive exam, rather than a series of exams.
4. Competencies falling under the umbrella of the Expert program may range from foundational skills to mastery of advanced technologies.
5. May have prerequisites such as an online exam, previous certification or training course attendance. 

Oracle certified specialist

The Oracle Certified Specialist branded credentials are typically foundation-level implementation-oriented certifications targeted at employees of current Oracle partners, employees of integrators seeking to become Oracle partners and individuals who plan to apply for work with Oracle-authorized partners. Additionally these certifications would be applicable to anyone who wishes to add credibility and broaden their skill sets on specific Oracle products. 

Java 7 Certification

Java 7 Release
After the take over of Sun Micro system by Oracle , release of Java 7 comes with new style of certification in oracle flavor. Actually its just in start phase of Java 7 certification called as 'Beta version' . It have some benefits or also some difficulties.Evaluated below :

Beta Certification
Actual price of a oracle certification is $125 but in case of Beta its become about $50.Beta version of certification comes only when there is new release of any product , to configure what suitable & appropriate question and format asked to student So Oracle use initial phase of analysis of certification questions.We will get after 11 weeks of finishing Beta exam, only those question will be considered for marks which are selected for non Beta exam .So take it on your risk if you are a expert then no problem at all.

Certification Path 
At the time of writing this blog Oracle introduce two level of certification given As:
1. OCA 7 - Java 7 programmer I
2. OCP 7 - Java 7 programmer II
Until now there is no release of of Java 7 OCM certification..Let us take a brief introduction  of both exams.

OCA 7 - Java 7 programmer I
The OCA, Java SE 7 Programmer certification is designed for individuals who possess a strong foundation in the Java Programming language. This certification covers the fundamentals of Java SE 7 programming, such as the significance of object-oriented programming and the steps to create simple Java technology programs. This certification provides a solid foundation on which to base continued learning.
study material Associate-Study-Guide-Oracle-Press

OCP 7 - Java 7 programmer II 

It's just under construction at the time of writing that blog ,course will be displayed after a month ago.As best of my knowledge there is not so much change between Java 6 & java 7 rather than project coin with some changes in API's .I suggest that not take that exam under Beta version. If you want to clear Java certification as early as then old version exam are also available.

Java 7 Certification 'A View '