Re: Help needed: OCP exam_cram book questons

Contrary to other replies in the first question answer c is correct.

The syntax for the concat function is
concat(<expression1>, <expression2>)
So expression1 needs to be evaluated first. Expression1 however is
LOWER(SUBSTR(description,10))
The syntax for the function is
lower(<expression>)
So the expression in the lower function needs to be evaluated first. This is the SUBSTR function.
Answer c is correct

With respect to question 39 the author must have swapped b and c

As to the last question I agree with your opinion.

Regards,

Sybrand Bakker, Oracle DBA

<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 Mon Jul 31 2000 - 00:00:00 CDT