Writing About Our Experiences With Oracle Databases
Friday May 18th 2012

Latest Topics

Using current_scn for RMAN incremental ? Think again..

I am bloging about experience we had using rman incremental backup for syncing standby database. We had a standby [Read More]

Poll on Sql Plan Management

Dominic is conducting poll on SPM and Sql Profiles usage on his website. Link can be found here  I have been using SPM [Read More]

Oracle Direct connector for HDFS

Some time back oracle had announced Oracle Big Data appliance. Along with this Oracle released Big Data Connectors to [Read More]

ORA-7445 core dump [kokscold()+849] from EM 12c

The first problem reported by my EM 12c is an ORA-7445 error. After checking the alert log following is the exact [Read More]

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]

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

terkel had this to say

I still dont get it, so if someone get the ewallet.p12 cwallet.sso files and the connect string (simply by reading/copy Read the post

Amit had this to say

hi Bhushan, Em should be pretty easy. I will try to do it in my test setup and document it. cheers Amit Read the post

bhushan had this to say

Hey Amit, Any Document to Setup the Dataguard using EM12C? Any tips any suggestion? Regards Bhushan 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 11 other subscribers

asd123