Re: Skill testing SQL question
Date: Fri, 05 Nov 1999 22:10:16 +0000
Message-ID: <382355C8.BC06DEC3_at_btinternet.com>
Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
From David P.
To Connor
- fair point if we all know Jonathan's skill level (as we do!). But the situation is that of an interview. Now I presume that Jonathan is never interviewed (no reason - Guru anyway) so Jonathan would not be in the context of an interview.
But if Mr Nobody (i.e. someone whose skill level is unknown) is asked the question -
which response would you as an interviewer be happy with?
the simple (and straightforward delete) - assuming no-one changed the tuples between your deletes
or
the correlated delete?
I know how I would reply.
But Jonathan has a good point - there is always a chance I suppose that you might miss-type your correlated delete and then it would end up taking longer than if you had just chosen the simpler route.
- David P.
>
>
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."
--------------DB93A084F8B1B4773A9C1FCA [Quoted] Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
From David P.
<p>To Connor
<p> -
fair point <i> if</i> we all know Jonathan's skill level (as
we do!). But the situation is that of an interview. Now I presume
that Jonathan is never interviewed (no reason - Guru anyway) so Jonathan
would not be in the context of an interview.
<p>But if Mr Nobody (i.e. someone whose skill level is unknown) is
asked the question -
<p>which response would you as an interviewer be happy with?
<p>the simple (and straightforward delete) - assuming no-one changed
the tuples between your deletes
<p>or <p>the correlated delete? <br> <p>I know how I would reply. <br> <p>But Jonathan has a good point - there is always a chance I suppose thatyou might miss-type your correlated delete and then it would end up taking longer than if you had just chosen the simpler route.
<br> <p>--- David P. <br> <br> <p>============================================================================== <br> <blockquote TYPE=CITE> <p>=========================================== <br>Connor McDonald <br>"These views mine, no-one elses etc etc" <br>connor_mcdonald_at_yahoo.com <p>"Some days you're the pigeon, and some days you're the statue."</blockquote> </html>
--------------DB93A084F8B1B4773A9C1FCA-- Received on Fri Nov 05 1999 - 23:10:16 CET