RE: who writes the OCP tests?

2003-10-22 Thread Pete Sharman
Not I, never even seen the questions to tell you the truth.  I believe
there's an email address you can raise exam issues with -
[EMAIL PROTECTED]  You might want to send this to them to see if they
have more relevant feedback than I'd ever have on this exam.

Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
Oh no, it's not.  It's much harder than that!
Bruce Pihlamae, long-term Oracle DBA
 


-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, October 23, 2003 3:49 AM
To: Multiple recipients of list ORACLE-L


all oracle employees? Are any of you involved in the 9i PL/SQL test? I just
took it today and passed it. I didnt study at all. 

Id like to state that it is an incredibly stupid test. Ive been told the
PErformance tuning one is bad also... 

Some gripes:

1. Only package that I was asked about was dbms_lob and of the 66 questions
maybe 5-7 were on this package so about 10%. 

2. 40-50% of the test was on triggers. A bit disproportionate dont you
think? 

3. I was asked about 6-8 questions on how to call procedures and functions
and they slipped in a few defaults to 'trick' you. That is WAY too many. 

4. Nothing on Arrays, PL/SQL tables, Bulk Binds, or dynamic sql. 

5. In my overview it said I need to study the following(but they never asked
me about them) UTL_TCP, UTL_HTTP, dbms_ddl.

DBMS_DDL is antiquated and I cant think of anything I need it for. I wrap
everything in execute immediate(which wasnt on the test). How many people
actually use UTL_TCP and UTL_HTTP anyway? I dont. Far more people use other
features that werent covered. 

im done griping. This was REALLY bad. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).


RE: who writes the OCP tests?

2003-10-22 Thread Khedr, Waleed
Probably a Sybase DBA

-Original Message-
Sent: Wednesday, October 22, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L


all oracle employees? Are any of you involved in the 9i PL/SQL test? I just
took it today and passed it. I didnt study at all. 

Id like to state that it is an incredibly stupid test. Ive been told the
PErformance tuning one is bad also... 

Some gripes:

1. Only package that I was asked about was dbms_lob and of the 66 questions
maybe 5-7 were on this package so about 10%. 

2. 40-50% of the test was on triggers. A bit disproportionate dont you
think? 

3. I was asked about 6-8 questions on how to call procedures and functions
and they slipped in a few defaults to 'trick' you. That is WAY too many. 

4. Nothing on Arrays, PL/SQL tables, Bulk Binds, or dynamic sql. 

5. In my overview it said I need to study the following(but they never asked
me about them) UTL_TCP, UTL_HTTP, dbms_ddl.

DBMS_DDL is antiquated and I cant think of anything I need it for. I wrap
everything in execute immediate(which wasnt on the test). How many people
actually use UTL_TCP and UTL_HTTP anyway? I dont. Far more people use other
features that werent covered. 

im done griping. This was REALLY bad. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).


Re: who writes the OCP tests?

2003-10-22 Thread Joe Testa
But now since you've discussed whats on the test, the oracle police will 
come and confiscate your certified copy of your completion certificate.

bwahahahahaha

Joe

[EMAIL PROTECTED] wrote:

all oracle employees? Are any of you involved in the 9i PL/SQL test? I just took it today and passed it. I didnt study at all. 

Id like to state that it is an incredibly stupid test. Ive been told the PErformance tuning one is bad also... 

Some gripes:

1. Only package that I was asked about was dbms_lob and of the 66 questions maybe 5-7 were on this package so about 10%. 

2. 40-50% of the test was on triggers. A bit disproportionate dont you think? 

3. I was asked about 6-8 questions on how to call procedures and functions and they slipped in a few defaults to 'trick' you. That is WAY too many. 

4. Nothing on Arrays, PL/SQL tables, Bulk Binds, or dynamic sql. 

5. In my overview it said I need to study the following(but they never asked me about them) UTL_TCP, UTL_HTTP, dbms_ddl.

DBMS_DDL is antiquated and I cant think of anything I need it for. I wrap everything in execute immediate(which wasnt on the test). How many people actually use UTL_TCP and UTL_HTTP anyway? I dont. Far more people use other features that werent covered. 

im done griping. This was REALLY bad. 

 



--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).


RE: who writes the OCP tests?

2003-10-22 Thread Jamadagni, Rajendra
I am using utl_tcp as we speak to send feeds out to our customers ... encrypted of 
course.  We have a program that uses utl_http to go to espn.com, fetch data, filter 
out what we need and use that to populate the database.

Yes, we do use it ... but I am not Oracle employee.
Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !


-Original Message-
Sent: Wednesday, October 22, 2003 1:49 PM
To: Multiple recipients of list ORACLE-L


DBMS_DDL is antiquated and I cant think of anything I need it for. I wrap everything 
in execute immediate(which wasnt on the test). How many people actually use UTL_TCP 
and UTL_HTTP anyway? I dont. Far more people use other features that werent covered. 

im done griping. This was REALLY bad. 

**
This e-mail message is confidential, intended only for the named recipient(s) above 
and may contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank you.
**4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).


Re: who writes the OCP tests?

2003-10-22 Thread Ryan
my point is that relative to 'execute immediate' how many people use
utl_tcp?

execute immediate isnt on the exam at all.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 2:04 PM


 I am using utl_tcp as we speak to send feeds out to our customers ...
encrypted of course.  We have a program that uses utl_http to go to
espn.com, fetch data, filter out what we need and use that to populate the
database.

 Yes, we do use it ... but I am not Oracle employee.
 Raj
 --
--
 Rajendra dot Jamadagni at nospamespn dot com
 All Views expressed in this email are strictly personal.
 QOTD: Any clod can have facts, having an opinion is an art !


 -Original Message-
 Sent: Wednesday, October 22, 2003 1:49 PM
 To: Multiple recipients of list ORACLE-L


 DBMS_DDL is antiquated and I cant think of anything I need it for. I wrap
everything in execute immediate(which wasnt on the test). How many people
actually use UTL_TCP and UTL_HTTP anyway? I dont. Far more people use other
features that werent covered.

 im done griping. This was REALLY bad.



**
 This e-mail message is confidential, intended only for the named
recipient(s) above and may contain information that is privileged, attorney
work product or exempt from disclosure under applicable law. If you have
received this message in error, or are not the named recipient(s), please
immediately notify corporate MIS at (860) 766-2000 and delete this e-mail
message from your computer, Thank you.


**4
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Jamadagni, Rajendra
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ryan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).