in reply to Perl Interviews

When I used to interview candidates for a SQL-related position, I would always ask the following:
If A has three rows and B has three rows then how many rows will the query 'Select * from A, B' return?

Most applicants got it wrong. The most common answer was six, but some people would say three. (The correct answer is nine.)

Replies are listed 'Best First'.
Re: Re: Perl Interviews
by davorg (Chancellor) on Feb 16, 2001 at 21:40 UTC

    Heh! Any SQL programmer who doesn't recognise a cartesian product would definitely be a liability on the team :)

    --
    <http://www.dave.org.uk>

    "Perl makes the fun jobs fun
    and the boring jobs bearable" - me