| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Help needed: OCP exam_cram book questons
hi,
I think the OCP test is easy for me. I have two years of Oracle and SQL. 7 years of UNIX and 10 years of computer science. I can help who want to pass the tests of Oracle.
Best wishes!
Yours sincerely, Xiaoliang Chen
Day phone: 1-714-870-0861 x130
Home phone: 1-714-738-3720
Mail:
1400 N. Harbor Blvd., Suite 601
Fullerton, CA 92835
My Homepage:
http://www.geocities.com/earnmuchmoney
----- Original Message -----
From: <Kimberly.smith_at_gmd.fujitsu.com>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Thursday, August 03, 2000 10:11 AM
Subject: RE: Help needed: OCP exam_cram book questons
> If you are truly serious about being a DBA then the certification
> exams are not that bad. You could plain old waste your time and
> memorize the book or you can use the book to help guide you in your
> learning process. I was already an experienced dba when I went
> and got my Oracle8 DBA certification but I dealt mostly with the
> Oracle7 versions of the database. I took this certification process
> as a means to forcing me to learn the new Oracle8 features and so
> far it has served me well.
>
> First off, no exam study book is 100% error free. Keep that in mind.
> The Oracle Press one seems to be the closest though. You need to
> create a database and try out the stuff you are learning.
>
> As others have mentioned, once you have being a DBA for a while there
> are things you learn where Oracle says one way but really its better
> off another way. Yes, the exam expects it Oracle's way. Adjust. There
> really is not to much of that. They are mostly tied to things like
> percentages and whatnot.
>
> There are things like OEM on the exam that I never use. I hate the
product
> and use either TOAD or command line but at the same time I have two
> backup DBA's here who do not do this full time and do not know all the
> command line things or even what to look for in the manuals. They
therefore
> use OEM. I have been able to help them learn quite a bit to improve
> their ability to use the tool to effectively do their job because of the
> crap the OCP exams made me go though. Therefore, it is not a waste of
time.
>
> So it comes down to, you can just get an OCP, or you can get an OCP and
> learn
> from the whole process. I intend to learn Oracle8i the exact same way.
> Of course it helps that my company pays.
>
>
> -----Original Message-----
> Chris
> Sent: Wednesday, August 02, 2000 4:27 PM
> To: Multiple recipients of list ORACLE-L
>
>
> So whatever happend to actually learning this stuff versus cramming for a
> test...
>
> -----Original Message-----
> Sent: Wednesday, August 02, 2000 4:48 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi!
>
> Oops u mean I should not have 'thrown out' those cram books?
> ie cram is good for clearing OCP?
>
>
> ------Original Message------
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: July 31, 2000 10:05:48 AM GMT
>
>
> you study the cram exam books or take the tests or guess right
>
>
>
> >From: Cyril Thankappan <cyril_thank_at_india.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: Help needed: OCP exam_cram book questons
> >Date: Sun, 30 Jul 2000 21:45:04 -0800
> >
> >Hi!
> >
> >Thanks Rachel for the 'insight'..
> >
> >But can u help me!
> >
> >Where can I get the 'scoring answers' (answers which
> >will get me marks!)
> >
> >Thanks
> >
> >------Original Message------
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Sent: July 31, 2000 3:04:00 AM GMT
> >
> >
> >The problem is, you can't necessarily understand the correct answer.
> >Because
> >the "correct" answer is not always the one that is really right.
> >
> >Oracle has decided that these are the answers. So they are the correct
> >ones,
> >even if you think they are wrong.
> >
> >I have a friend who finally managed to pass the Performance Tuning exam
by
> >answering questions deliberately wrong -- because she knew that the
"wrong"
> >answer was the one Oracle wanted on the exam.
> >
> > >From: "Guang Mei" <zlmei_at_hotmail.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > >Subject: Help needed: OCP exam_cram book questons
> > >Date: Sun, 30 Jul 2000 15:24:44 -0800
> > >
> > >Hi:
> > >
> > >I was reading the OCP review book "EXAM_CRAM" (author: Michael Ault)
and
> > >have a few questions about the sample test questions. I would like to
> >know
> > >the "coorect" answer and understand why.
> > >
> > >Here it goes:
> > >
> > >-------------------
> > >Question 27:
> > >
> > >You query the database with this command:
> > >
> > >SELECT
> > >CONCAT(LOWER(SUBSTR(description,10)),
> > >LENGTH(product_name)) "Product ID"
> > >FROM inventory;
> > >
> > >Which function is evaluate second?
> > >a CONCAT()
> > >b. LOWER()
> > >c. SUBSTR()
> > >
> > >According to the book:
> > >The correct answer is c. Answer a is incorrect because CONCAT() is
> >outside
> > >of the parantheses. Answer b is incorrect because LOWER() is not inside
> >the
> > >innermost parentheses.
> > >
> > >
> > >I thought the answer should be b. Why am I wrong here?
> > >
> > >-------------------
> > >Question 39:
> > >
> > >What is the purpose of the PL/SQL FETCH command?
> > >
> > >a. To define a cursor to be used later
> > >b. To retrieve values from the active set into local variables
> > >c. To call the rows identified by a cursor query into the active set
> > >d. To relase the memory used by the cursor
> > >
> > >According to the book:
> > >The correct answer is c. The fETCH command retrieve values returned by
> >the
> > >cursor into the active set. Answer a is incorrect because this
statement
> >is
> > >the function of the CURSOR command. Answer b is incorrect because this
is
> > >the function of OPEN command. Answer d is incorrect because this is the
> > >function of the CLOSE command.
> > >
> > >I thought the answer should be b. Again, why am I wrong here?
> > >
> > >-------------------
> > >Question 34:
> > >
> > >Which Procedure Builder component would you use to edit the properties
of
> > >your database objects?
> > >
> > >a. Stored Program Unit Editor
> > >b. Program Unit Editor
> > >c. PL/SQL Interpreter
> > >d. Object navigator
> > >
> > >
> > >My question (to all people who took OCP PL/SQL exam recently) is: Does
> > >exam
> > >cover specific oracle tool such as "Procedure Builder" or "OEM"? It
> >seems
> > >that PL/SQL should not test any specfic tools , especially tools that
are
> > >not widely used. Rather it should test the knowledge of PL/SQL.
> > >
> > >-----------------
> > >
> > >Thanks in advance.
> > >
> > >Guang
> >
>________________________________________________________________________
> > >Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com
> > >
> > >--
> > >Author: Guang Mei
> > > INET: zlmei_at_hotmail.com
> > >
> > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > >San Diego, California -- Public Internet access / Mailing Lists
> > >--------------------------------------------------------------------
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from). You may
> > >also send the HELP command for other information (like subscribing).
> >
> >________________________________________________________________________
> >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> >--
> >Author: Rachel Carmichael
> >INET: carmichr_at_hotmail.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
> >
> >
> >______________________________________________
> >FREE Personalized Email at Mail.com
> >Sign up at http://www.mail.com/?sr=signup
> >
> >--
> >Author: Cyril Thankappan
> > INET: cyril_thank_at_india.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
> ______________________________________________
> FREE Personalized Email at Mail.com
> Sign up at http://www.mail.com/?sr=signup
>
> --
> Author: Cyril Thankappan
> INET: cyril_thank_at_india.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Author: Grabowy, Chris
> INET: cgrabowy_at_fcg.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Author:
> INET: Kimberly.smith_at_gmd.fujitsu.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
Received on Thu Aug 03 2000 - 13:36:06 CDT
 |
 |