Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: NEED ORACLE interview questions?

Jared Still

2006-06-28

Replies:

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@comcast.net> 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.
>>
>>

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





--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.