SQL

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:

Coding

Considering the following tables

City

Columns: city_id (int), city_name (char(100)), country_id (int) foreign key on Country(country_id)

Country

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.