Re: Help needed: OCP exam_cram book questons

Maybe the LENGTH function is evaluated first, and then the SUBSTR function.

??

Tom Best

<gmei_at_my-deja.com> wrote in message news:8m2995$lup$1_at_nnrp1.deja.com...
> 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
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Jul 30 2000 - 00:00:00 CDT