Skip to content
SQL
MIDDLE

Music Store | Time Function Test for Middle SQL Developer | PostgreSQL

Overall seniority level
Middle
Test duration
53 minutes
Evaluation
Automatic

Test overview

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

Task types

Code gaps

SQL | PostgreSQL | CHECK constraint code gap assessing knowledge of PostgreSQL, SQL

Level: Medium

Tested skills: PostgreSQL, SQL

Code gaps

SQL | PostgreSQL | Date extraction code gap assessing knowledge of PostgreSQL, SQL

Level: Medium

Tested skills: PostgreSQL, SQL

Code gaps

SQL | PostgreSQL | Inheritance code gap assessing knowledge of PostgreSQL, SQL

Level: Medium

Tested skills: PostgreSQL, SQL

SQL task

SQL | PostgreSQL | Music Store | Time function - Calculate the duration of all songs in each cd and output a list.

Level: Medium

Tested skills: PostgreSQL, SQL

Code gaps

SQL | PostgreSQL | CASE statement code gap assessing knowledge of PostgreSQL, SQL

Level: Medium

Tested skills: PostgreSQL, SQL

Choice questions

6 choice questions assessing knowledge of Logical thinking, PostgreSQL, Soft Skills, SQL

Level: Medium

Tested skills: Logical thinking, PostgreSQL, Soft 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.