Other

Other 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.

MIDDLE
Tested skills
Duration
44 minutes max.
Evaluation
Manual
Test overview

Choice questions

assessing knowledge of Arrays, Data Step, SAS, Databases, frequency tables, statistics, ODS, reports, Macro language

Code gaps

assessing knowledge of Analytics, SAS, TTest, statistics, Data Step, PROC SQL

Code review task - Level: Medium

SAS | Reading and filtering data - Verify the quality of code that uses data manipulation and macro language statements and add comments on how to improve it. Remember to optimise the code’s performance and follow SAS best practices.

SENIOR
Tested skills
Duration
41 minutes max.
Evaluation
Manual
Test overview

Choice questions

assessing knowledge of GLM procedure, SAS, statistics, Data Step, Hash, Databases, Macro language, conditional formatting, reports

Code review task - Level: Hard

SAS | Macrodefinitions - Verify the quality, efficiency and readability of the code which creates a new macrodefinition named split and add comments on how to improve it. Remember to optimise the code’s performance and follow SAS best practices.

JUNIOR
Tested skills
Duration
42 minutes max.
Evaluation
Manual
Test overview

Choice questions

assessing knowledge of SAS, reports, Data Step, Excel, Macro language, means procedure, statistics, Databases

Code gaps

assessing knowledge of Data Step, PROC SORT, SAS, reports

Code review task - Level: Easy

SAS | Data manipulation - Verify the quality of code that uses data manipulation and add comments on how to improve it. Remember to optimise the code’s performance and follow SAS best practices.

DevSkiller logo TalentBoost logo TalentScore logo