Test SQL Data Design

Test SQL with answers to assess your knowledge and prepare for job interviews. Assess your technical level in 20 minutes.

Validate and promote your skills
Private results unless you share them
Compare your results to the developers average

My Results

Test details

Intermediate
December 2023
46 minutes
4.5/5(14)

SQL (acronym for Structured Query Language) is a standardized computer language used to use relational databases. The data manipulation language part of SQL allows you to find, add, modify or delete data in relational databases.
Creating a robust and scalable database is a complex subject that requires experience and basic knowledge.
This test is based on a concrete example of a customer who wishes to implement a database and will validate your skills on these subjects:

  • Good practices
  • Diagrams
  • Joins
  • Redundancy
  • Data consistency
This test consists of 20 questions randomly selected from a database of 11 questions in SQL.Discover all our interview questions and answers here
⚠️ Ranking results of all timemay not be relevant because the test has not been taken enough times yet.
1.
developer avatar
Nathalie Lafond
2583 points
2.
developer avatar
Youssef
2583 points
3.
developer avatar
dhhd
2583 points
4.
developer avatar
Othmane
2442 points
5.
developer avatar
yas
2423 points

Test author : Clément Devos

This quiz was designed by WeLoveDevs.com team.

Contributors2
developer avatar
developer avatar

Sample question

THIS BLOCK IS THE SAME FOR ALL QUESTIONS

You must design a landscaper marketplace.

A person can register as a landscaper. She then chooses the services she offers from a pre-established list. She then declares - by selecting on a calendar - her availability (a start date and an end date, the days are always whole).

Another person can register on the site as a client. She can then select the service or services she is looking for. A list of landscapers is then presented to her with a filter that allows only landscapers available for certain days / periods to be presented.

If the client finds an adequate landscaper, he can then select the dates he actually needs and then place an order.

All quiz questions refer to this problem.

####Two important constraints are added to answer the questions:

No data redundancy is tolerated.

We will consider the storage of structured data (table, hash, json, etc.) in a single data field impossible.

In the relationship between clients and orders, the foreign key is located

See 11 test questions.Participate in test improvement

Developers ratings

developer avatar
Ruthu Kumari
09/05/2024
Great questions . Very useful to check my knowledge
developer avatar
Sandrine
30/03/2024
developer avatar
18/03/2024
developer avatar
Ali
26/09/2023
J'ai passé plusieurs tests pour embauche. Les résultats étaient catastrophes c'est pourquoi j'ai choisi de passer le maximum de tests
developer avatar
05/09/2023
très bon test pour connaitre son niveau