Re: NEED ORACLE interview questions?

Funny.

When I interview for positions that require SQL knowledge, I
spring a test on them.

Most do OK.  One guy argued with me that an outer join was
not necessary in the answer to one of the questions.

I disagreed.  He argued his point, none too tactfully.  Interview over. ;)

Jared

On 6/27/06, Michael Haddon <m.haddon@xxxxxxxxxxx> wrote:


One I used to love to give (really tests their ability to listen)

Whats wrong with this statement

delete colA, colB, colC from TableA
where ColA = :a and ColB = :c;

you would be very surprised at the answers, I was.

I even had one guy tell me the ":" wasn't legal syntax.

Mike

>On 06/27/2006 08:30:02 AM, dba1 mcc wrote:
>
>
>>Anyone has web site for ORACLE interview questions?
>>
>>Thanks.
>>
>>

--
//www.freelists.org/webpage/oracle-l

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

References:
- NEED ORACLE interview questions?
  - From: dba1 mcc
- Re: NEED ORACLE interview questions?
  - From: Mladen Gogala
- Re: NEED ORACLE interview questions?
  - From: Michael Haddon