SQL quiz advanced level

Test description

This quiz was designed to check your advanced knowledge of SQL (ANSI).
Topics: SQL, RDBMS, VIEWS, JOINS.

Sample questions

SELECT City FROM Customers
UNION
SELECT City FROM Suppliers
ORDER BY City;

Error

Selects all the values of City from Customers and adds distinct City values from Suppliers

Selects all distinct City values from Customers and Suppliers

Selects all the values of City from Suppliers and adds distinct City values from Customers