Assess a SQL Server database developer applicant's skills with this TSQL test

 

Pre-test scrip 

Before I start the test, I need a schema and some data torun the queries against.

Listing A

 

 

will create what I need.

Once I have the data loaded, Ican start working on the test questions. (Tip:I like to have the applicant save the numbered SELECT/UPDATE/INSERT/DELETEstatements he or she writes into a text file, so that I can view them later atmy leisure.)