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