JUNIOR

Stamps catalogue | CASE statement Test for Junior Data Engineer | SQL, MongoDB

Overall seniority level: Junior
Test duration: 27 minutes
Evaluation: Automatic
Tested skills:: SQL Mongo MySQL MongoDB NoSQL SELECT

Test overview

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

Task types

Code gaps

NoSQL | Mongo | Query | Arrays code gap assessing knowledge of Mongo, MongoDB, NoSQL

Level: Easy

Tested skills: Mongo, MongoDB, NoSQL

Code gaps

NoSQL | Mongo | Query | Count documents code gap assessing knowledge of Mongo, MongoDB, NoSQL

Level: Easy

Tested skills: Mongo, MongoDB, NoSQL

Code gaps

SQL | Between operator code gap assessing knowledge of SQL

Level: Easy

Tested skills: SQL

SQL task

SQL | MySQL | Stamps catalogue | CASE statement - Make a select statement, by which you will divide your stamps collection into 3 groups.

Level: Easy

Tested skills: MySQL, SQL

Code gaps

SQL | Update operator code gap assessing knowledge of SQL

Level: Easy

Tested skills: SQL

Choice questions

5 choice questions assessing knowledge of MongoDB, MySQL, NoSQL, SELECT, SQL

Level: Easy

Tested skills: MongoDB, MySQL, NoSQL, SELECT, SQL

Automatic evaluation

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