Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: who writes the OCP tests?

RE: who writes the OCP tests?

From: Khedr, Waleed <Waleed.Khedr_at_fmr.com>
Date: Wed, 22 Oct 2003 12:09:34 -0800
Message-ID: <F001.005D3FDA.20031022120934@fatcity.com>


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: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

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

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.COM
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: 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 Wed Oct 22 2003 - 15:09:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US