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