40 Minutes
 20 Questions

This test is designed to assess a student's knowledge of technology, SQL, and related concepts. It will cover the basics of SQL, such as data types, commands, and query syntax. Additionally, it will also include questions on logic and problem-solving related to SQL queries. The test is intended to evaluate a student's understanding of the fundamentals of technology and SQL.

Example Question:

Considering the following tables
Columns: city_id (int), city_name (char(100)), country_id (int) foreign key on Country(country_id)
Columns: country_id (int), country_name(char(100))
What SQL statement will return all cities with countries where they are situated?
Note: In case when country is not defined for city (country_id in City table is null) city must be returned with empty country column.