Test your developers

     Still working on evaluating automatically what students can do, SQL-wise, I have posted a new by-product. It's a "click to reconstruct the query" exercise which actually runs the result, returns syntax errors when the statement makes no sense, and recognizes both

    where a = b
      and c = d

and

    where d = c
      and a = b

and all possible combinations as valid, since they will return the same dataset. The test database is composed of the states of India this time; by the way, if anybody knows what will be the ISO 3166 code for Telangana ... Wake up, ISO committees, less than one month left. I have assigned 'TE', which seems unused, but it's a bet.

There are 5 questions. A friend of mine who is a Java developer told me he had the first right and failed at the second one. Why wasn't I surprised?

The link is http://edu.konagora.com/SQLtest.php. The Challenge (far more difficult) is still here, replace 'test' by 'challenge'.

Have fun,  

-- 
Stéphane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>
Author, SQL Success


<http://www.amazon.com/SQL-Success-Database-Programming-Proficiency/dp/1909765007/>,

The Art of SQL


<http://www.amazon.com/Art-SQL-Stephane-Faroult/dp/0596008945/>,

Refactoring SQL Applications


<http://www.amazon.com/Refactoring-SQL-Applications-Stephane-Faroult/dp/0596514972/>



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