RE: Developer Interview Questions?

In addition to SQL tuning, the prospective employee should know what cursor variables are, bind variables, and the advantages of using them.

The hopeful candidate should also know how to minimize opening cursors through reuse, or at least not look like a scared deer in the headlights when
asked about it.

Excellent paper on this by Bjorn Engsig at http://otn.oracle.com/deploy/performance

Jared

John Kanagaraj <john.kanagaraj_at_hds.com>
Sent by: root_at_fatcity.com
02/15/02 01:38 PM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.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).