SENIOR

Fill sparse table

Test for Senior Database Developer | SQL

Overall seniority level

Senior

Test duration

45 minutes

Evaluation

Automatic

Tested skills:

Test overview

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

Task types

SQL task

SQL | 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 SQL

Level: Hard

Tested skills: SQL

Automatic evaluation

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