RE: Developer Interview Questions?

Jay,

I would feel that PL/SQL tuning is the same as SQL tuning. Just pull out one of your complicated Explain Plan or TKProf outputs and ask the Interviewee (is there such a word?) to explain the meaning. Also quiz him/her about the various joins and the approach he/she would take when a DBA/User complains of a slow query - If 'trace file', 'tkprof' and 'explain plan' don't appear in the answer, then you may as well stop the interview :)

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Grace - Getting something we don't deserve Mercy - NOT getting something we deserve

Click on 'http://www.needhim.org' for Grace and Mercy that is freely available!

• The opinions and statements above are entirely my own and not those of my employer or clients **

> -----Original Message-----
> From: Miller, Jay [mailto:JayMiller_at_TDWaterhouse.com]
> Sent: Friday, February 15, 2002 10:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Developer Interview Questions?
>
>
> I've been asked to conduct a technical interview for a new
> PL/SQL developer,
> with an emphasis on performance tuning issues (which is why
> I'm doing it
> instead of one of the existing developers who seem to have
> some difficulty
> with the idea of running something through Explain Plan
> before sending it to
> me to go into production - I usually do all the SQL tuning).
>
> I've put together a few things but wondered if anyone could
> point me to a
> document with some good interview questions (I've only conducted DBA
> technical interviews in the past).
>
>
> Thanks!
> Jay Miller
> x48355
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Miller, Jay
> INET: JayMiller_at_TDWaterhouse.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).