Writing About Our Experiences With Oracle Databases
Thursday February 9th 2012

Latest Topics

Copying Oracle Scheduler jobs with Arguments

Oracle provides dbms_scheduler.copy_job function to copy oracle scheduler jobs which works great. But problem is that [Read More]

EM12c:Automated discovery of Targets

EM12c:Automated discovery of Targets

In this post we will discuss the Automated discovery of Targets in Enterprise Manager Cloud Control(EM 12c). Once you [Read More]

Em12c:Silent Oracle Management agent Installation

This Post would describe how to install Oracle Management Agent 12c in silent mode. We need to download the agent [Read More]

11gR2:Listener Startup Issues

In this blog post I will be discussing listener startup issues faced in 11gR2 RAC. I will be constantly updating this [Read More]

Get Upgrading: Upgrade to Enterprise Manager Cloud Control 12c

Get Upgrading: Upgrade to Enterprise Manager Cloud Control 12c

This post describes the steps to upgrade an existing 11g Enterprise Manager Grid Control (11.1.0.1.0) to 12c [Read More]

Changes To 10g OCA Certification

People planning to appear for  10g OCA Exam will be startled to find that they need to pass additional exam to get the certificate. Starting from December 1, 2008, in addition to the existing exam (Oracle Database 10g: Administration I (1Z0-042)), candidates are also required to pass any one of the four following Oracle SQL exams to earn the certification:

Introduction to Oracle: SQL® and PL/SQL™ (1Z0-001) or,
Introduction to Oracle9i: SQL (1Z0-007) or,
Oracle Database 11g: SQL Fundamentals I (1Z1-051) or,
Oracle Database SQL Expert (1Z0-047)

People who have cleared the IZ0-042 exam before 30 Nov 2008 are not required to give the exam. Below is snapshot from Oracle website detailing new Certification Path. You can find the details here

10g_certification1

Share
Related Tags: , ,

5 Comments for “Changes To 10g OCA Certification”

  • Laurent Schneider says:

    Come on, being an Oracle Certified SQL Expert enables you to apply for the OCA certificate? Oracle Education just confuses the customer more and more…

  • Tim Hall says:

    Hi.

    The DBA track should include an SQL component. It always used to, then Oracle removed to reduce the number of exams required to get the OCP. Adding an SQL compnent is necessary as a DBA without SQL is not a DBA in my opinion.

    I agree with Laurent, the SQL expert doesn’t really seem appropriate as a lead in to DBA OCA, but then I guess any proof of SQL skills is fine.

    Cheers

    Tim…

  • Amit says:

    Tim,

    Yeah. I too gave 9i OCP and cleared the SQL exam and then upgraded to 10g. But strangely it was removed from 10g. Now it’s been brought back clearly shows that people thought that it was important subject which should be part of 10g course. Anyways I came across this info on education site while checking pre-requisites for OCM course :)

    Laurent,

    As Tim pointed out, SQL Expert won’t be asked to write in separate exam to showcase his skills while appearing for 10g OCA. We can say that with this a SQL expert need to give only one exam to become OCA instead of writing 2 :)

    Cheers
    Amit

  • Israel says:

    i need past questions for my iz0-047 exams coming up soon. please send it to my mial idusraels@yahoo.com

  • Israel says:

    i need past questions for my iz0-047 exams coming up soon. please send it to my mail idusraels@yahoo.com


Leave a Comment

*

Recent Comments

Amit had this to say

Thanks mindinpanic. I have incorporated the comment in article. Appreciate your input. Read the post

mindinpanic had this to say

Sorry for my bad english((( And 6 step is that you must run sqlpus from bin directory of your oracle server Read the post

Claudiomiro Caetano had this to say

Simple and effective. Thanks a lot, it solved my issue. Read the post

More from category

Copying Oracle Scheduler jobs with Arguments

Oracle provides dbms_scheduler.copy_job function to copy oracle scheduler jobs which works great. But problem is that [Read More]

10gR2 Silent Install with 11gr2 CRS fails

I was trying to perform a 10.2 silent install with 11gR2 CRS. While doing pre-checks installer failed with following [Read More]

10.2 CRS startup issue

Today I faced a strange issue with CRS  post host reboot. CRS was not coming up and we could see following message in [Read More]

Performance Management Guide on AIX

While trying to find the amount of physical memory used by oracle process on AIX, I got reference of a document from [Read More]

Effect Of Multiple SHMMAX Settings

Last week I saw a warning message at database startup time saying: WARNING: EINVAL creating segment of size [Read More]

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 4 other subscribers