Archive for the 'Oracle' Category

Oracle DBA Certification

OCP DBA

Oracle DBA Certification

racle DBA Certification: Introduction Currently Oracle DBA track is available for 2 versions of Oracle: 8i and 9i. Both Oracle 8i and Oracle 9i are equally popular in the industry. So choosing the track depends mainly on your personal preference and work requirements.

Oracle has officially announced the retirement of Oracle8i DBA OCP track on December 31, 2004. The aspirants preparing for the same will have to complete the required core Oracle8i DBA exams in this track by December 31, 2004. Those who would have acquired this certification by then will continue to retain their credential even after the track expires. The retirement of exams included in this track will not apply to the other Oracle certifications in which they appear.

If you are planning to go for 9i track, you have an option of taking the Oracle 8i track first and than take the upgrade exam for 9i certification, or directly go for 9i certification track. Choosing the first option helps you get around Oracle's mandatory training for 9i since OCPs in 8i are exempted from that requirement.

How to prepare for DBA?

You have identified your goal and are ready to prepare yourself for the highly recognized DBA Certification Exam. You want to score high, the course is large and the time is less. The Question is:

How to prepare fast and accurate?
How to focus on important topics first, master them fast, and retain what you've learnt?

Learn how to master the course and prepare scientifically through Whizlabs Preparation Kit with the help of DBA Exam Preparation Guide.

A DBA can do the following
DBA is responsible for designing and maintaining an organization's database.
DBA ensures that the data is available only to the authorized users.
DBA has complete jurisdiction over the organization's database.

 Oracle 9i DBA Path Details

Oracle Administrator track for Oracle 9i has been divided into the following three levels.
1. Associate Level (2 Exams). You need to clear the following exams:

Exam #1Z0-001 Introduction to Oracle: SQL and PL/SQL
OR

Exam #1Z0-007 Introduction to Oracle 9i: SQL (online also)
Exam #1Z0-031 Oracle 9i Database: Fundamentals I

2. Professional Level (2 Exams and one Oracle University hands-on course within the Oracle 9i DBA learning path). You need to clear the following exams:

Oracle 9i Database: Fundamentals II (#1Z0-032)

Oracle 9i Database: Performance Tuning (#1Z0-033)

Note: If you do not want to take the hands-on course from Oracle you can clear the Oracle 8i track first (5 exams) and then take the upgrade exam (1 exam).

3. Master Level.
A candidate must take two advanced DBA courses from Oracle University. For details you can visit Advanced Courses of Oracle University.

Oracle 8i DBA Path Details
Option 1: If you have not taken any of the Oracle tests till now, you need to clear the following exams:
Exam #1Z0-001 Introduction to Oracle: SQL and PL/SQL OR
Exam #1Z0-007 Introduction to Oracle9i: SQL (online also)

Exam #1Z0-023 Oracle 8i: Architecture and Administration

Exam #1Z0-025 Oracle 8i: Backup and Recovery
Exam #1Z0-024 Oracle 8i: Performance Tuning
Exam #1Z0-026 Oracle 8i: Network Administration

Option 2: If you are DBA on Oracle 8 and want to upgrade to oracle 8i, you need to clear the following exam:

Exam #1Z0-020 Oracle8i: New Features for Administrators

Option 3: If you are DBA on Oracle 7.3 and want to upgrade to oracle 8i, you need to clear the following exam:

Upgrade Exam: Oracle 7.3 to Oracle 8 OCP DBA
Oracle8: New Features for Administrators (#1Z0-010)

Upgrade Exam: Oracle 8 to Oracle 8i OCP DBA
Oracle8i: New Features for Administrators (#1Z0-020)
Resources

Tags:

Related posts

Which Oracle Certification track should you seek?

Which Oracle Certification track should you seek?

Database Administrator: Database Administrators are responsible for administrative activities like installing database, taking backups, managing and fine-tuning performance over the network, and data recovery. They have the knowledge of basic architecture of the Oracle database. Visit Track page to gain detailed information about the exam, its details, types of questions, and how to prepare for the exam, if you are interested in taking the OCP-DBA certification. Application Developer: Application Developers are responsible for developing applications on Oracle. They should have a good knowledge of SQL, PL/SQL, and developing Internet applications using Form Builder and Report Builder. Visit Oracle Application Developer Certification Track page to gain detailed information about the exam, its details, types of questions, and how to prepare for the exam, if you are interested in taking the OCP Developer certification. When should you think of Oracle Certification? Oracle University is constantly upgrading the OCP certification tracks to groom professionals to work with new Oracle products. Once you have completed one of the tracks of your choice, you just need to take just few exams (usually 1) to upgrade yourself in a new version. Therefore, we think taking certification exams is a continuous process. It is a structured way to update your knowledge with changes in technology. So, you should think of Oracle Certification from the day you decide to work in Oracle to the day you actually start working with Oracle. Once you have decided which Oracle Certification Track to go for, download the Candidate Guide for the OCP track you are pursuing. The guide contains test topics, preparation, and registration material. It is highly recommended by the Oracle Certification Program that candidates review the Test Content Checklist before completing an exam. You may also review the Checklist online. According to Certmag's 2003 Salary Survey: 71% of respondents felt self-study books were valuable in preparing for the exam. 67.6% of respondents felt that practice exams, such as exam simulators were valuable in preparing for the exam. Why Oracle Certifications? Oracle Certification brings a higher standard of benchmarked skills and abilities, which leads to greater opportunities and higher pay packages. According to Information Week Magazine, "Oracle is the #1 skill sought by IT managers, and is the hardest to find." A research conducted by International Data Corporation revealed the following: OCP Certified professionals handled 40% more support calls, and their employers have reported 49% less system downtime. For the majority of companies surveyed, the savings from increased effectiveness paid the costs of certification in fewer than 9 months. Certmag's 2003 Salary Survey states the following: Respondents with specialization in Database Administration had an average annual salary of $70,590. 76% of respondents reported that certification gives them higher level of confidence in the work they do. 70% said that being certified earns them more respect from mangers and peers. 61% have seen a greater demand for their skills since becoming certified. 64% said certification has improved their problem solving skills. And 60% believe certification has contributed to increased productivity.

Tags:

Related posts


Close
E-mail It