| 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
I think that c is right answer because the
second part of concat function will execute first and length function will
be execute first, when first part of concat function will execute the substr
function
will be execute so right answer is substr.which is c
Shahid Malik.
-----Original Message-----
From: Rachel Carmichael [mailto:carmichr_at_hotmail.com]
Sent: Monday, July 31, 2000 8:04 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Help needed: OCP exam_cram book questons
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).
-- 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 mayReceived on Mon Jul 31 2000 - 00:28:25 CDT
 |
 |