Joins

Question 1

Returns all values from one table even if match not found

Answer 1

Outer Join

Question 2

All requested results, values of common columns returned only once. Duplicate
column eliminated. If there are no common column names, NATURAL JOIN results
into a CARTESIAN PRODUCT (CROSS JOIN)

Answer 2

Natural Join

Question 3

Uses only field values in tables that are equal. Returns all requested results including values of common columns.

Answer 3

Equi Join

Question 4

Requires each record in two tables to have matching records.

Answer 4

Inner Join

Weird wording. It selects matching values in 2 tables.

Question 5

Joins rows based on matched values and returns rows from both tables.

Answer 5

Full Outer Join

Question 6

Joins rows based on matched values. The result includes unmatched rows from the
table on the left of the JOIN clause.

Answer 6

Left Outer Join

Question 7

Joins rows based on matched values. The result includes unmatched rows from the
table on the right of the JOIN clause.

Answer 7

Right Outer Join

Question 8

Joins the table to itself

Answer 8

Self Join

Question 9

Cartesian product of tables. Combines each row from the first table with each row from
the second table

Answer 9

Cross Join

Question 10

Returns a table that includes all data from each table. Both tables (or views) must
have the same number of columns and the data types of both columns must be same.
Strictly, not a join.

Answer 10

Union