This exercise assesses SQL skills. It also assesses the ability to interpret data models, interpret questions, attention to detail and data wrangling.
This is a free practice Alooba World exercise. For the SQL exercise you will need to write SQL queries which will be validated against a database.
Your query output will be compared with the expected output for the question. You will be awarded full marks if the output matches the expected output, and some partial marks if your answer is close. The outputted column names are not considered, only the order of the outputted columns. Ensure you read the question thoroughly and provide the output expected.
Ensure you execute your query and check the output before submitting. You may execute your queries as many times as needed. The database will be reset to its initial state before each execution.
The exercise lasts for 8 minutes and contains 1 question.
This exercise is designed to be completed on a desktop or laptop.
You will complete your details on the next page and receive the unique link via email.
Best of luck!
Your queries will be executed using a database engine which is compliant with the majority of basic SQL syntax. Ensure your queries use ANSI SQL. You cannot use any database specific functions or syntax.
A few points when writing your queries:
Note, this free test is only a small sample of what’s available on Alooba. Our paid product has 3500+ questions, across 50+ technical skills, soft skills, personality and intelligence.
Looking to assess your team or candidates? For more information about how to test your employees or candidates’ SQL skills, feel free to contact us, book in a demo or get started testing immediately by signing up here.