Joins and changes quiz

  • Admin
  • 1 min read

Nine questions on INNER and LEFT JOIN, subqueries, and writing rows safely.

SQL

Joins and changes quiz

9 questions, instant feedback

Question 1 of 9 What does an INNER JOIN return?
Question 2 of 9 What does a LEFT JOIN keep that an INNER JOIN drops?
Question 3 of 9 Which condition belongs in the ON clause of a LEFT JOIN to keep unmatched rows?
Question 4 of 9 Why use table aliases?
Question 5 of 9 What is a correlated subquery?
Question 6 of 9 Which statement adds a row?
Question 7 of 9 What happens to UPDATE without a WHERE clause?
Question 8 of 9 Which type should a price column use?
Question 9 of 9 Which statement creates a table?

Your answers stay in this browser. Nothing is sent to a server.