Help needed: OCP exam_cram book questons:

From: <gmei_at_my-deja.com>
Date: 2000/07/30
Message-ID: <8m297s$luf$1@nnrp1.deja.com>#1/1

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

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Jul 30 2000 - 00:00:00 CDT