Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: anyone who know some good SQL interview questions?

Re: anyone who know some good SQL interview questions?

From: Aloha Kakuikanu <aloha.kakuikanu_at_yahoo.com>
Date: 7 Nov 2006 16:19:25 -0800
Message-ID: <1162945165.903999.108720@h54g2000cwb.googlegroups.com>

Christopher Browne wrote:
> Quoth Bob Badour <bbadour_at_pei.sympatico.ca>:
> > c++student wrote:
> >
> >> Hi
> >> Do anyone who know or has the links to some good SQL interview
> >> questions?
> >> Thanks
> >
> > If you actually learn the material, it won't matter what questions
> > they ask you.
>
> If you had some good questions, that could be handy. Some of us have
> involvement with trying to *hire* would-be DBAs...

Here are 2:

  1. How do you do hierarchical query query. (Being asked this back in 1997 @yahoo. Also heard somebody else asked it as well).
  2. Name various aggregate string concatenation methods. Not all of them are created equal from performance perspective, of course. The most efficient solutions are the one with user-defined aggregation and the other one leveraging collect function. Don't hastily dismiss the rest, however. If nothing else, the problem of writing a list aggregate is still a great job interview question. You can rate someone's SQL skills (on the scale 0 to 6) by the number of different approaches that she can count.
Received on Tue Nov 07 2006 - 18:19:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US