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

Answers

  1. SELECT c.city_name, cntr.country_name
FROM city c
RIGHT OUTER JOIN country cntr
ON c.country_id = cntr.country_id

  2. SELECT c.city_name, cntr.country_name
FROM city c
JOIN country cntr
ON c.country_id = cntr.country_id

  3. SELECT c.city_name, cntr.country_name
FROM city c
LEFT OUTER JOIN country cntr
ON c.country_id = cntr.country_id