Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Help needed: OCP exam_cram book questons
Hi!
Oops u mean I should not have 'thrown out' those cram books? ie cram is good for clearing OCP?
------Original Message------
From: "Rachel Carmichael" <carmichr_at_hotmail.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: July 31, 2000 10:05:48 AM GMT
Subject: Re: Help needed: OCP exam_cram book questons
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).Received on Wed Aug 02 2000 - 14:39:02 CDT