Skip to content

Fill sparse table Test for Senior Database Developer | SQL

Overall seniority level
Test duration
45 minutes
Tested skills:

Test overview

Test is combined from various tasks. SQL task and Choice questions. All evaluated automatically.

Task types

SQL task

SQL | MySQL | Fill sparse table - Write a query that will return the list of all users with the creation date and return the date from the previous not-null row for the entries affected with the bug.

Level: Hard

Tested skills: HSQLDB, MySQL, SQL

Choice questions

5 choice questions assessing knowledge of MySQL, SQL

Level: Hard

Tested skills: MySQL, SQL

Automatic evaluation

We automatically score multi-choice tests and programming tasks and evaluate candidate code for logical correctness, time efficiency and code quality.