| 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
Not wanting to start a LOOOONG thread again but I had to add a buck or two =
to the pot.
NOTHING beats experience.period. I am sure that there are a lot of DBA's =
doing a fantastic job and saving thier company a lot of time and money =
that do NOT have thier OCP yet. I applaud them for thier ability and =
perserverence, but working the job and taking the test are two different =
things. Knowing how to do and what to do may not be the answer they are =
looking for when they word the test. The MOST CORRECT answer from the =
choices given may not bet the real world CORRECT answer. Of those of use =
that have taken the test, How many of the answers would have been "MORE =
CORRECT" if they had supplied the real world answer as a chioce?=20
Keep in mind that the questions and answers are not platform specific. Yea =
Right!. If all of your experience in on one platform "and you are good at =
what you do" you may have difficulties answering some of the questions. =
That is one of the reasons to inhance your knowledge with the CRAMS,etc =
before you take the tests.
As an example: The test questions ask about Oracle products that can be =
purchased to make the DBA interface a GUI rather than command line. They =
do not work on all platforms and are very costly. With out the books to =
learn from I would have been quessing at the answers. I now have the =
knowledge and the resources to use the products in the future at another =
work location.
"As he steps down off the soap box, goodday,goodnight,goodluck"
Ron Rogers
DBA OCP
Atl.GA
>>> cgrabowy_at_fcg.com 08/02/00 07:27PM >>>
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=20
>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=20
> >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=
=20
> >
> >--
> >Author: Guang Mei
> > INET: zlmei_at_hotmail.com=20
> >
> >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=
=20
>
>--
>Author: Rachel Carmichael
>INET: carmichr_at_hotmail.com=20
>
>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=3Dsignup=20
>
>--
>Author: Cyril Thankappan
> INET: cyril_thank_at_india.com=20
>
>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=20 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=3Dsignup=20 --=20 Author: Cyril Thankappan INET: cyril_thank_at_india.com=20 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). --=20 Author: Grabowy, Chris INET: cgrabowy_at_fcg.com=20 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 - 07:45:08 CDT
 |
 |