Online store stock Test for Middle SQL Developer | MSSQL
- Overall seniority level
- Middle
- Test duration
- 65 minutes
- Evaluation
- Automatic
- Tested skills:
Test overview
Test is combined from various tasks. SQL tasks. All evaluated automatically.
Task types
SQL task
SQL | MSSQL | Finding duplicates - Write a query that will return the names of all items that have multiple clone entries in the database.
Level: Medium
Tested skills: MSSQL, QA, SQL
SQL task
SQL | MSSQL | Finding date ranges - Write a query that returns the names of all items added within the last 7 days.
Level: Medium
Tested skills: MSSQL, QA, SQL
SQL task
SQL | MSSQL | Using aggregates - Write a query that returns the number of gadgets (not their stock) that are listed under the "Branding" category.
Level: Medium
Tested skills: MSSQL, QA, SQL
SQL task
SQL | MSSQL | Finding nulls - Find all faulty items in the database according to the above observation.
Level: Easy
Tested skills: MSSQL, QA, SQL
Automatic evaluation
We automatically score multi-choice tests and programming tasks and evaluate candidate code for logical correctness, time efficiency and code quality.