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. ;)
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.
>On 06/27/2006 08:30:02 AM, dba1 mcc wrote: > > >>Anyone has web site for ORACLE interview questions? >> >>Thanks. >> >>
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist