SQL Joins Quiz

A clause that filters rows from a table based on a condition

A clause that creates a new table from columns of one or more tables (correct)

A clause that renames columns in a table

A clause that sorts columns in a table in ascending or descending order

A sorted table based on a column

A filtered table based on a condition

The Cartesian product of rows from tables in the join (correct)

A table with renamed columns

An inner join returns only matching rows, while a cross join returns all possible combinations of rows (correct)

An inner join combines columns from one or more tables into a new table, while a cross join filters rows based on a condition

An inner join returns all possible combinations of rows, while a cross join returns only matching rows

An inner join filters rows based on a condition, while a cross join combines columns from one or more tables into a new table