RE: Help needed: OCP exam_cram book questons

From: Cyril Thankappan <cyril_thank_at_india.com>
Date: Mon, 31 Jul 2000 01:10:32 -0400 (EDT)
Message-Id: <10574.113334@fatcity.com>

I'm sorry but the moment u said u've read Michael ault.. I didn't even read the question

In PL/SQL cram for oracle8 DBA
he says user can alter profile.. I was shocked and rushed to my office to check it!!!!!!!

after that threw out all cram books and back to manuals now!!

Yes that way I may land up not having a OCP (anytime in life!!!)

------Original Message------

From: "Guang Mei" <zlmei_at_hotmail.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: July 30, 2000 11:24:44 PM GMT
Subject: Help needed: OCP exam_cram book questons

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?

To define a cursor to be used later
To retrieve values from the active set into local variables
To call the rows identified by a cursor query into the active set
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?

Stored Program Unit Editor
Program Unit Editor
PL/SQL Interpreter
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).


______________________________________________

Received on Mon Jul 31 2000 - 00:10:32 CDT