Prerequisites
For Oracle 9i Certified Professional DBA Credentials
To successfully become an Oracle 9i Certified Professional Database
Administrator, you need to pass the following four exams:
- 1Z0-007 - Introduction to SQL
- 1Z0-031 - Database Fundamentals 1
- 1Z0-032 - Database Fundamentals 2
- 1Z0-033 - Database Performance Tuning
When you successfully complete the first two exams
i.e. 1Z0-007 and 1Z0-031, you acquire the Oracle 9i Certified Associate
Database Administrator Certification.
When you successfully complete all the four exams
listed above, you achieve the Oracle 9i Certified Professional Database
Administrator Certification.
In order to achieve your OCP credential you must also complete at
least one of the following Oracle University hands-on courses:
- Introduction to Oracle9i: SQL
- Oracle9i Database: Fundamentals I
- Oracle9i Database: Fundamentals II
- Oracle9i Database: Performance Tuning
- Oracle9i New Features for Administrators
- Introduction to Oracle: SQL and PL/SQL
This requirement applies to all those OCP candidates who have taken
their first OCA Exam on or after September 1, 2002. If you have earned
OCA or even registered for any of the exams before September 1, 2002
then you do not have to complete the course requirement.
Learn
More about the latest details about the OCP DBA Exams.
1Z0-033 Exam Details
Exam 1Z0-033 is the fourth exam of the Oracle 9i Certified Professional
(OCP) Track. This exam covers the performance tuning issues related
to the Oracle database, the instance and the underlying platform.
This Exam contains 59 scored questions, out of which
you need to answer at least 38 questions correctly to pass this
exam. Thus, the passing percentage is 64%. Total time allotted for
the same is 90 minutes.
There may be some questions that are not scored but
you cannot differentiate the scored questions from those that are
not scored so attempt all the questions.
Types of questions
(1) Multiple Choice Single Response:
In this category, there are multiple choices given for each question;
from those choices you have to select ONE correct choice only.
(2) Multiple Choice Multiple Responses:
In this category, there are multiple choices given for each question
and you have to select multiple answers, the number of answers that
you need to select is specified in the question.
|
Effective
online ads.  |
|
Exam Objective
Oracle Corporation has compiled a list of objectives that are tested
in this exam. To view these objectives on the Oracle site click
here.
These objectives will be described in the following
section. In each objective, I have put NOTES that will specify the
areas that you cannot afford to ignore before taking the exam. If
you have any doubts about the areas covered in the NOTES, then you
need some more preparation before taking the exam.
NOTES are not exhaustive, they are an indicator of
what you should study in depth, and therefore will point you towards
the right direction for exam preparation.
| Objective |
Credibility |
| 1) Overview of Oracle 9i Performance Tuning |
* |
| 2) Diagnostic and Tuning Tools |
** |
| 3) Sizing the Shared Pool |
*** |
| 4) Sizing the Buffer Cache |
*** |
| 5) Sizing Other SGA Structures |
*** |
| 6) Database Configuration and I/O Issues |
*** |
| 7) Optimize Sort Operations |
*** |
| 8) Diagnosing Contention for Latches |
** |
| 9) Tuning Rollback (UNDO) Segments |
*** |
| 10) Monitoring and Detecting Lock Contention |
** |
| 11) Tuning Oracle Shared Server |
** |
| 12) Application Tuning |
** |
| 13) Using Oracle Blocks Efficiently |
** |
| 14) SQL Statement Tuning |
** |
| 15) Tuning the Operating System and Resource Manager
|
** |
Note:
*** Maximum Credits
** Intermediate Credits
* Least Credits
Read
the Full Article
About the Author:
Ravi Bhateja, a graduate in Physics from Bombay University and an
experienced Oracle Database Administrator and Developer (SQL and PL/SQL)
has authored the content for Whizlabs OCP 1Z0-033 exam simulator.
Ravi is an Oracle9i DBA Certified Professional and also a Sun Certified
Programmer for Java 2 Platform. He has acquired great ken and expertise
in the field of database administration and programming.
The author can be contacted at authors@whizlabs.com.
About Whizlabs
Whizlabs(www.whizlabs.com),
an ISO Certified company, is a leading provider of IT skill assessment
and certification exam preparation tools. Whizlabs' suite of offerings
include "IT Certification Exam simulators and Instructor-led,
Online Trainings" for various exams by Sun, IBM, Oracle, Microsoft,
BEA, Cisco, and other leading IT vendors and "IT skill Assessment
Management Solution" for Corporations, Training Institutes, and
Universities.In its first 3 years of inception Whizlabs has helped
300,000 software professionals in realizing their dream of acquiring
IT Certifications of their interest. Whizlabs offerings have fuelled
the career growth of IT professionals working in 321 Fortune 500 companies
spread in 118 countries across the globe.
Read This Newsletter at:
http://www.itcertificationnews.com/2004/0526.html |
|
By
Ravi Bhateja
