HomeCode HereJoins and changes quiz Joins and changes quiz Admin 1 min read Updated November 16, 2026 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? A All rows from both tables B Only rows with a match in both tables C Only rows from the left table D Rows with no match INNER JOIN keeps pairs where the join condition is true, so unmatched rows on either side are dropped. Question 2 of 9 What does a LEFT JOIN keep that an INNER JOIN drops? A Duplicate columns B Left-table rows with no match, filled with NULLs C Right-table rows with no match D Rows with NULL keys LEFT JOIN returns every row from the left table, using NULLs for columns of the right table when no match exists. Question 3 of 9 Which condition belongs in the ON clause of a LEFT JOIN to keep unmatched rows? A A filter on the right table's columns B A filter on the left table's columns C The join key comparison D ORDER BY Conditions on the right table in WHERE turn the join back into an inner join. Put them in ON if unmatched rows must survive. Question 4 of 9 Why use table aliases? A To rename the table permanently B To shorten references and disambiguate columns C To improve indexing D To hide columns Aliases such as o and c make qualified columns readable, and they are required when both tables have a column with the same name. Question 5 of 9 What is a correlated subquery? A A subquery in the SELECT list only B A subquery that references the outer query's columns C A subquery that returns many columns D A subquery in a JOIN A correlated subquery is evaluated per outer row because it refers to that row's values, which can be slower than a join. Question 6 of 9 Which statement adds a row? A INSERT INTO t (a, b) VALUES (1, 2) B UPDATE t SET a = 1 C ALTER TABLE t ADD a D SELECT INTO t INSERT adds rows. UPDATE changes existing ones, and ALTER TABLE changes the structure. Question 7 of 9 What happens to UPDATE without a WHERE clause? A It updates the first row B It updates every row C It fails D It updates no rows Without WHERE, the statement applies to the whole table. Run the same predicate as a SELECT first. Question 8 of 9 Which type should a price column use? A REAL B TEXT C INTEGER stored as paise or cents D BLOB Floating point cannot represent most decimal amounts exactly. Store the smallest currency unit as an integer and format for display. Question 9 of 9 Which statement creates a table? A MAKE TABLE B CREATE TABLE C NEW TABLE D ADD TABLE CREATE TABLE defines columns, types and constraints. It is the statement you run once, usually in a migration file. Check my answers Try again Your answers stay in this browser. Nothing is sent to a server. More quizzes Summarising data quiz 9 questions Design and safety quiz 9 questions SQL final quiz 10 questions All quizzes