| 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
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-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Grabowy,
Chris
Sent: Wednesday, August 02, 2000 4:27 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Help needed: OCP exam_cram book questons
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).
-- 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 messageReceived on Thu Aug 03 2000 - 10:51:16 CDT
 |
 |