Re: Help needed: OCP exam_cram book questons:

Answers inline....

> 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?

The answer will be c. It's kind of a tricky question. The first function evaluated is the LENGTH function. The SUBSTR function is evaluated next. This is cuz the CONCAT function will concat the results of the LENGTH function with the "modified" results of the SUBSTR function.  

> -------------------
> 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?

You are right here. Answer 'a' is performed by the CURSOR command. Answer 'c' is performed by the 'OPEN' command. Answer 'd' is performed by the CLOSE command. That just leaves answer 'b'. This is a case where the book contained an error.

> -------------------
> 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.

The OCP exams do not cover these tools in any depth. At least this was the case for the Oracle 7 and 8 OCP exams. I'm not sure about the Oracle 8i exams.

HTH,
Brian  

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================