Oracle’s 9i OCP (Oracle Certified Professional) DBA (Database
Administrator) certification is a mid-level certification for IT
professionals who manage large-scale databases or develop applications
that are used enterprise-wide. The Oracle 9i OCP was introduced in late
2001 and will likely stay very popular until the arrival of the Oracle 10G
certification. There is no specific prerequisite for this certification;
however, by starting your Oracle certification journey on the 9i path, you
will achieve the OCA (Oracle Certified Associate) certification along the
way.
Be sure you know all the syntax, rules and DEFAULT values for defining and
using sequences. It’s hard to know which functions the test will quiz you
on, but be familiar with the basic ones including, but not limited to:
TO_CHAR, NUMBER, SUBSTR, UPPER, LOWER, NVL, SUM, COUNT, DISTINCT. The
more functions you know the better off you will be.
Understand the structures, use of different type of cursors, and error
handling in PL/SQL. Also know how to use the GROUP BY and HAVING clauses.
Know how to create views and the rules for what can and cannot be
included in a view definition.
Most of the test questions are scenario based, with some being more
complicated than others. Some of the scenarios contain extra
non-important information and exhibits. You need to be able to pick out
the "facts from the fiction". The tests will usually start off with a
very complex scenario based question on some of the more obscure topics.
Don’t get thrown off by this trap. Don’t be afraid to mark a difficult
question and return to it later, while answering the questions you know
first.
The above all are the outcome of my research on OCP certification. I too
going fro that.
Received on Sat Jun 18 2005 - 01:06:38 CDT
