Help needed: OCP exam_cram book questons

From: Guang Mei <zlmei_at_hotmail.com>
Date: Sun, 30 Jul 2000 22:13:47 GMT
Message-Id: <10574.113321@fatcity.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?

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

1. Stored Program Unit Editor
2. Program Unit Editor
3. PL/SQL Interpreter
4. 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 Received on Sun Jul 30 2000 - 17:13:47 CDT