Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: OCP exam reading list

Re: OCP exam reading list

From: Mark D Powell <markp7832_at_my-deja.com>
Date: 2000/04/10
Message-ID: <8csk1v$r4g$1@nnrp1.deja.com>#1/1

Yes, I believe a person can pass the OCP exams using only the Oracle manuals to prefare. The SQL and DBA Admin exams in particular can be passed based on experience and accumulated knowledge since that is how I prepared. The other examinations are a little bit harder using only the manuals, but I believe it can be done. If you have some money but not enough to take very many cources I would recommend (based on word of mouth from associates who took classes) the you take Backup and Recovery, Performance and Tuning, and Net 8. The rman commands and syntax is laid out for you in the student notes but just there in the manual and picking out the more important stuff is difficult.

In article <38EFE2EB.AFAF8340_at_yahoo.com>,   oracle8i <yuchinc_at_yahoo.com> wrote:
> Mark,
>
> Thank you very much for your quality of recommendations.
> I totally agree with you.
> But I wonder if there are people really pass the DBA exams by reading
 FREE
> manuals.
> Maybe I should just take ORACLE courses to take the exams.
> I hope I have money to do that.
> Thanks!
>
> yuchinc_at_yahoo
>
> markp7832_at_my-deja.com wrote:
>
> > The best reference for any of the OCP examinations is the student
 notes
> > from the Oracle class for that topic. I have seen a couple of the
> > manuals and they appear to cover everything on the examination for
 that
> > topic. If you can not go to Oracle's class or borrow a student
 manual
> > then I recommend what I studied.
> >
> > Basic SQL and PL/SQL - SQL Manual ch 1 - 3 plus review most used
> > commands in ch 4, i.e., create table, index, etc...; Read all of
 select
> > command; For pl/sql read how to declare variable and about looping.
> > There is very little pl/sql on the exam.
> >
> > DBA Admin - The Concepts manual; It would also not hurt to take this
> > test after the SQL and Backup tests since there is some overlap on
 this
> > test. If you have time read DBA Admin manual also.
> >
> > Backup and Recovery - The backup and recovery manual; Also the
 Utility
> > manual on imp, exp, and sqlldr. If memory serves me correctly these
> > last three items appeared on the DBA exam also.
> >
> > Performance and Tuning - The Performance and Tuning Manual
> >
> > Net 8 - Net 8 Administration Manual
> >
> > I do not think after the student notes that there is any better
 souce
> > than the manuals. I have purchased one of the OCP prep books by
 Ault
> > and do not think it was worth the money. I made the effort to read
 the
> > manuals.
> >
> > In article <h7vG4.932$5e.82721_at_newshog.newsread.com>,
> > "Van Messner" <vmessner_at_bestweb.net> wrote:
> > > For 8i, the Oracle concepts documentation is great for the
 concepts
> > > test. Unfortunately there really isn't an outstanding source for
 backup and
> > > recovery. On the older test the Oracle Press book was good, but
 it
 doesn't
> > > really do much of anything with RMAN. Even the Oracle Backup and
 Recovery
> > > documentation has many more errors and typos than you'd normally
 expect.
> > > But it's probably the best you can do.
> > > There are a million choices for SQL and PL/SQL - let your
 personal
> > > preference decide.
> > >
> > > Van
> > >
> > > oracle8i <yuchinc_at_yahoo.com> wrote in message
> > > news:38EA44C5.93BEB72A_at_yahoo.com...
> > > > I would love to hear from oracle fellows how you prepare the OCP
 exam.
> > > > Especially a reading list you think might be useful based on
 your
> > > > experiences.
> > > > I am preparing for ORACLE 8i DBA exams, thought there are only
 three
> > > > tests available so far.
> > > > The first test is old, so I think there are many people have
> > > > experiences.
> > > > I would appreciate it if you could share your experiences with
 me.
> > > > Thanks in advance!
> > > >
> > > > Eric C.
> > > > yuchinc_at_yahoo.com
> > > >
> > >
> > >
> >
> > --
> > Mark D. Powell -- The only advice that counts is the advice that
> > you follow so follow your own advice --
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Apr 10 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US