Logical thinking

Logical thinking online coding tests & interview questions

SQL
JUNIOR
Tested skills
Duration
25 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of Logical thinking, Math, MySQL, SQL

Code gaps

assessing knowledge of SQL

Task - Level: Easy

SQL | MySQL | Stamps catalogue | AVG Function - Select the stamps (name and price) with price greater than or equal to the total average price.

SQL
MIDDLE
Tested skills
Duration
53 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of SQL, PostgreSQL

Code gaps

assessing knowledge of PostgreSQL, SQL

Task - Level: Medium

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

SQL
JUNIOR
Tested skills
Duration
26 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of Logical thinking, SQL

Code gaps

assessing knowledge of SQL

Task - Level: Easy

SQL | PostgreSQL | Hotels - average prices - Prepare the report with the average prices in the cities.

SQL
JUNIOR
Tested skills
Duration
27 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of Logical thinking, SQL

Code gaps

assessing knowledge of SQL

Task - Level: Easy

SQL | PostgreSQL | Hotels - bookings - Prepare the booking list with a number of days, price per day and total price of the stay.

SQL
SENIOR
Tested skills
Duration
52 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of Logical thinking, SQL

Task - Level: Hard

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.

.NET
JUNIOR
Tested skills
Duration
71 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of Logical thinking

Code gaps

assessing knowledge of .NET Core, .NET Internals, dotnet build, dotnet test, dotnet restore

Programming task - Level: Easy

.NET | .NET Core , Microservices | Traffic volume registration API - Finish the implementation of two microservices which collect data from sensors. Required functionality has to be implemented in the proper service and other services (subscribers) must be informed about new data.

DevSkiller logo TalentBoost logo TalentScore logo