Hotels – cities and top hotels Test for Senior SQL Developer | PostgreSQL
- Overall seniority level
- Senior
- Test duration
- 52 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 | PostgreSQL | Hotels - cities and top hotels - Prepare a list of cities with the date of last reservation and a main photo (photos[0]) of the most popular (by number of bookings) hotel in this city.
Level: Hard
Tested skills: PostgreSQL, SQL
Choice questions
5 choice questions assessing knowledge of Logical thinking, MySQL, Soft Skills, SQL
Level: Hard
Tested skills: Logical thinking, MySQL, Soft Skills, SQL
Choice questions
1 choice questions assessing knowledge of Logical thinking, Soft Skills
Level: Medium
Tested skills: Logical thinking, Soft Skills
Automatic evaluation
We automatically score multi-choice tests and programming tasks and evaluate candidate code for logical correctness, time efficiency and code quality.