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 

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 '