How to Clear Oracle Certification ... ?

Tips:
Oracle Certification - Tips

DBA Preparation - Tips

Practical DBA - Tips

How to Clear Oracle Certification?

There are couple of questions come in mind when anyone think about oracle certification.

1. Is Oracle Certification is beneficial for Job Seekers?
You know what is certification…?
It is just some couple of questions which based 80% on concept and theory.
And any Job opening wants Practical DBA means Practical Experience with Theory.

So as per my advice any oracle newbie first get some practical experience then go for certification.


2. How to prepare for Oracle Certification?
Oracle Certification is examination, so some rules apply which we follow in our college examination.
1. First define which Oracle Paper you want to write.
Go through below link and choose your paper
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=42&p_org_id=1080544&lang=US
2. Second check Exam Topic, Objective.
Suppose we choose “izo-007” introduction to SQL paper. So now check what is exam topic is come in “introduction to SQL paper”. Because SQL is very big topic and exam question based on some most important chapters.
Check Exam topic for “introduction to SQL” paper
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_org_id=1080544&lang=US&p_exam_id=1Z0_001#3

3. What is Oracle Exam format?
Whenever anybody going to write first time oracle paper then always worry about exam format. Now don’t worry Oracle provide demo for exam format.
1. Oracle Exam is objective types
2. For demo version please go through below link (paper:iz0-007)
http://www.selftestsoftware.com/demo/default.aspx

3. What material we used for preparation?
1. Best material is “student guide” simple, easy and short.
Student Guide books comes with Oracle Course Kits.
2. Oracle Documentation
http://tahiti.oracle.com
3. Practice Questions
On internet there are so many site which provide us practice question for oracle certification.

http://www.google.ae/search?hl=en&q=practice+question+oracle&meta=

4. Looking for Dumps?
You know what is Dumps?
Dumps are real question which comes in Oracle Certification.
Some centre sold exam question like dumps for money and it is illegal please check it below link
http://www.oracle.com/global/us/education/certification/canagreemt.html
And suppose you will get dumps from anywhere …so please don’t depend on it.
It is not sure all question comes from dumps.
Because some prometric centre keeps real question in their centre and refresh periodically. But some prometric centre like oracle prometric centre use main server through internet.

Related Links

1. http://dbataj.blogspot.com/2007/10/why-i-choose-oracle-as-my-career.html

2. http://dbataj.blogspot.com/2007/09/faqs-about-oracle-certification.html

3. http://dbataj.blogspot.com/2007/08/oracle-plsql-developer-certified.html

4. http://dbataj.blogspot.com/2007/08/oracle-11i-apps-dba.html

5. http://dbataj.blogspot.com/2007/03/oracle-certified-professional.html

Why I Choose Oracle as my Career ?

Dear Friends,

There are some question which asked frequently on forms from every oracle newbie.

1. Which Oracle Certification I choose ?
Here I will explain in details.

There types of Oracle Certification we can do.
1. Oracle DBA
2. Oracle Developer
3. Oracle Application DBA

1. Oracle DBA
The person which maintain Oracle Database called Oracle Database Administrator.
There are some frequent work for Oracle DBA
1. Database Backup Responsibity.
2. Database Performance Tunning
3. Database Basic Administration Like " user creation, database security"
Above work is complete dedicated to Oracle DBA and every company which use Oracle Database they always need Oracle DBA.

Certification: Oracle 9i
http://dbataj.blogspot.com/2007/08/oracle-9i-certified-professional.html

Certification: Oracle 10g
http://dbataj.blogspot.com/2007/03/oracle-certified-professional.html2. Oracle Developer
The person which create coding and design forms and report for front-end application
There are some frequent work for Oracle Developer
1. Coding
2. Create and Design Forms and Reports
3. SQL Tunning
Above work is complete dedicated to Oracle Developer

Certification: Oracle9i,10g
http://dbataj.blogspot.com/2007/08/oracle-forms-developer-certified.html


3. Oracle Application DBA

The Person which work on ERP (enterprise resource planning)
There are some frequent work for Oracle Application DBA
1. Implement Oracle ERP according company requirement.
2. Patching and Clonning
3. Maintain Application Module like "financial,hr etc"

Certification: Oracle10g
http://dbataj.blogspot.com/2007/08/oracle-11i-apps-dba.html
________________________________________________________________

2. From where I get Real Time Exprience ?

This is very most important and difficult question :)

because without exprience we can't get job or without job we can't get real time exprience :)

So First understand what is real time exprience ?
Read Time exprience means where so many users working in your Oracle DB and DBA have to maintain that database, if any error comes DBA have to fix as soon as possible.

This exprience we can't get without Job ?
Ans: Yes,

Now if we remove REAL TIME word in exprience then we can get only exprience without Job ?
Ans: Yes,

How ? i will show you.

First understand what is exprience ?
Exprience means we have to good concept with some practical knowledge in Oracle DB.

Now Question is how can get good concept knowledge with some pratical knowledge ?

1. Buy On PC with minimum 512 RAM with 80 harddisk.
2. Install Oracle 10g Database or Oracle 11g
It is free you can download here
http://www.oracle.com/technology/software/products/database/index.html

Note: Oracle 11g is also released on Windows or Linux Platforms

3. Download below books from Oracle Documentation
1. Oracle Concept
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm

2. Oracle Administrator Guide
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/toc.htm

3. Oracle Sql Reference Guide
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm

4. Oracle Performance Tunning Guide
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm

4. Now start reading with step by step first read 1 pointed books then 2 and so on.

5. If you face in problem means any error message or anything which you don't understand then please refer oracle forms.
1. Oracle OTN forms
http://forums.oracle.com/forums/category.jspa?categoryID=18
2. OraFAQ forms
http://www.orafaq.com/forum/
3. Asktom
http://asktom.oracle.com/pls/asktom/f?p=100:1:4506654324364228

4. Some Oracle guru's Blog
http://jonathanlewis.wordpress.com/
http://tkyte.blogspot.com/
http://tonguc.wordpress.com/
http://jaffardba.blogspot.com

I am not Oracle Guru's but visit my blog also :)
http://dbataj.blogspot.com
http://babudba.blogspot.com
http://sabarsyed.blogspot.com
5. Some good Site
http://www.akadia.com/
http://www.adp-gmbh.ch/
http://www.psoug.org/

After Follow above instruction you will be very good Oracle Knowledgable person.
________________________________________________________________

3. How can I get Oracle Job ?

What you think after complete Second point (above) you will not get job ?
Ans: NO, we will get job...hurrrey :)

But also keep in mind below things when you going for interview
1. Make sure you have very good RESUME/CV created.
If anybody want to know about how to create CV for oracle please email me at asktaj i will check and correct your CV.

2. First decide In which subject you are very powerful ?
1. Administration
2. Backup and Recovery
3. Performance Tunning

3. Good Dress Code

________________________________________________________________

Hope this article give you good understand about Oracle Certification , Exprience and Job.

Please give me your comments.
Thank You

FAQ's about Oracle Certification

1. Available Certification Exams

Exam List


2. Oracle Certification Program Beta Exams
Exam List

3. Oracle Testing and Registration
Detail Informations

4. Hands On Course Requirement Form
Detail Informations

5. Approved list of Oracle University Courses for Hands on Course Requirement
Detail Informations

6. Pratice Tests
Defail Informations

7. Oracle Certification Candidate Guide
Defail Informations

Oracle Enterprise Linux Certified Administrator

Oracle University is very excited to announce a new Linux System Administrator certification track based upon Enterprise Linux. The new track will consist of OCA and OCP levels that will closely map to Oracle's new Linux training offerings.
To become certified, candidates must demonstrate a high level of proficiency with Enterprise Linux including:

System administration
Networking
Security

At the OCP level the required exams will consist largely of performance-based,hands-on exercises and scenarios. Potential candidates

Oracle Certified Professional

Enterprise Linux Fundamentals
1Z0-402
OR CERTIFICATION

1Z0-403
Enterprise Linux System Administration
Release date TBD

Oracle9i DBA OCPs to Oracle Database 10g

Oracle9i DBA OCPs to Oracle Database 10g

Required or Recommended Training

Exam Details



Oracle OCP 10g

Oracle Database 10g: Managing Oracle on Linux Certified Expert

Oracle Database 10g: Managing Oracle on Linux Certified Expert

Paper Require:

1. Oracle10g OCA OR Oracle10g OCP OR Managing Oracle on Linux for DBAs
+
IZO-046 Beta Exam
+
Hands On Course Requirement Form

Oracle Forms Developer Certified

Oracle PL/SQL Developer Certified Associates 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.

Paper Require

Oracle PL/SQL
Developer Certified Associate

+

Oracle Forms: Build Internet Applications IZO-141

Oracle PL/SQL Developer Certified Associate

Oracle PL/SQL Developer Certified Associates 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.

Paper Require

Introduction to Oracle9i: SQL® IZO-007

OR


Introduction to Oracle: SQL® and PL/SQL IZO-001

+

Program with PL/SQL IZO-147

Oracle Forms Developer Certified

Oracle 11i Apps DBA

Oracle Applications DBA Certified Professionals demonstrate the complete set of skills required for working independently as experts in this role. An Oracle Applications DBA assumes the role of a database administrator on Oracle9i Database or Oracle Database 10g, with a focus on E-Business 11i Applications. Certified Applications DBAs are able to effectively manage the overlying database applications, including file system management, installation, maintenance using AD utilities, patching and cloning. They are also proficient with the underlying database architecture and configuration, including managing the database instance, managing objects and storage structures, performing backup and recovery, monitoring, performance tuning and troubleshooting.

Paper Require

Training Details

IZO-235

IZO-236

IZO-233

Hands On Course Requirement Form

Oracle PL/SQL Developer Certified Associate

Oracle 9i Certified Master

Oracle 9i---> Oracle Certified Master

Paper Require


Oracle 9i Certified Professional

+

Training Details

+

Oracle9i Database Administrator Certified Master Exam

+

Hands On Course Requirement Form



Oracle 10g OCA

Oracle 9i Certified Professional

Oracle 9i ---> Oracle Certified Professional

Paper Require:

Oracle Certified Associate

+

Training Details

+

Oracle9i Database: Fundamentals II IZO-032

+

Oracle9i Database: Performance Tuning IZO-033

+

Hands On Course Requirement Form





Oracle 9i OCM

Oracle 9i Certified Associate

Oracle 9i ---> Oracle Certified Associate

Paper Require

Introduction to Oracle 9i:SQL IZO-007

or

Introduction to Oracle: SQL® and PL/SQL IZO-001

+

Oracle9i Database: Fundamentals I IZO-031



Oracle 9i OCP

Oracle Certified Master

Oracle 10g---> Oracle Certified Master

Oracle Database 10g Administrator Certification combines training, experience, and testing to ensure that you have a strong foundation and expertise in the industry’s most advanced database management system.

Paper Require: OCP + TRAINING + EXAM + FORM ===> OCM


Training Details



Exam details



Form details



Oracle 11i Apps DBA

Oracle Certified Professional

Oracle 10g --->Oracle Certified Professional

The Oracle Database 10g OCP is a credential for serious database professionals who have the skills to implement and manage complex Oracle Database 10g functions and the know-how to keep the database running at maximum efficiency. Acquiring an OCP credential is a real professional accomplishment that requires training and hands-on experience.

Paper Require : OCA + IZO-043 Oracle Database 10g Administration II
Exam Details :
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_org_id=44&lang=US&p_exam_id=1Z0_043

Hand On Course Requirement
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=99



Oracle 10g OCM

Oracle Certified Associate

Oracle 10g --->Oracle Certified Associate
The Oracle Database 10g OCA is the first step in the Oracle Database 10g certification track and is the first step in building a successful career as an Oracle professional.

Paper Require : IZO-042 Oracle Database 10g Administration I
Exam Details :
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_org_id=44&lang=US&p_exam_id=1Z0_042


Oracle 10g OCP