Skip to content

HSQLDB

Looking for something similar? Try:
SQL developer interview questions and tests

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
JUNIOR
Tested skills
Duration
33 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of Logical thinking, SQL, MySQL

Code gaps

assessing knowledge of MySQL, SQL

Task - Level: Easy

SQL | MySQL | Stamps catalogue | A Self JOIN - Select stamps (name and location) that are in the same location.

Data Science
JUNIOR
Tested skills
Duration
45 minutes max.
Evaluation
Automatic
Test overview

Task - Level: Easy

SQL | Stamps catalogue | The three highest prices - Select three stamps (price and name) with the highest price.

Programming task - Level: Easy

Python | Pandas | HTML table parser - Implement a function to convert HTML table into a CSV-format file.

MongoDB
MIDDLE
Tested skills
Duration
51 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of SQL, MongoDB, NoSQL

Code gaps

assessing knowledge of MongoDB

Task - Level: Medium

SQL | Customer Data - Find all the customers whose first and last names are not unique in this database, as well as the number of times each first and last name pair appears in the database.

MongoDB
SENIOR
Tested skills
Duration
56 minutes max.
Evaluation
Automatic
Test overview

Choice questions

assessing knowledge of SQL, MongoDB, NoSQL

Code gaps

assessing knowledge of MongoDB

Task - Level: Hard

SQL | Fill sparse table - Write a query that will return the list of all users with the creation date and return the date from the previous not-null row for the entries affected with the bug.

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

Choice questions

assessing knowledge of SQL, MySQL

Task - Level: Medium

SQL | Customer Data - Find all the customers whose first and last names are not unique in this database, as well as the number of times each first and last name pair appears in the database.