Inner Joins

A table alias can consist of a maximum of ____ characters.

30

A(n) ____________________ join is required when a table must be joined to itself.

SELF

Equality, non-equality, and self-joins are all categorized as inner joins.

True

The most common type of join is an equijoin, which joins two or more tables together based upon the tables having equivalent data values in a common column.

True

Which of the following terms refers to a column with equivalent data that exists in two or more tables?

common column

In which of the following examples is the ORDERS table used as a column qualifier?

orders.order#

The JOIN keyword is included in which of the following clauses?

FROM

Which of the following is an example of assigning "o" as a table alias for the ORDERS table in the FROM clause?

FROM orders o, customers c

A column qualifier indicates the column containing the data being referenced.

False

A table alias is assigned to a table in the WHERE clause.

False

A(n) non-equality join is when a table is joined to itself.

False

The JOIN keyword is used in the WHERE clause to indicate the tables that should be joined or linked.

False

The ____________________ keywords create a join automatically between two tables, based on columns with matching names.

NATURAL JOIN

Which of the following can only be used to link tables that have a common column?

NATURAL JOIN

Using the JOIN...____________________ keywords to join two tables requires that a condition be specified to indicate how the tables are related.

ON

Which of the following SQL statements will display all customers who have not recently placed an order

SELECT customer# FROM customers MINUS SELECT customer# FROM orders;

A Cartesian join usually results from the user omitting the joining condition that links two or more tables together.

True

A(n) inner join will only include rows that have matching rows in the other table.

True

If a Cartesian join is used to link table A which contains two rows to table B which contains eight rows, there will be sixteen rows in the results.

True

Tables can be joined in the FROM clause or the WHERE clause of a SELECT statement.

True

A join based upon a column from each table containing equivalent data is known as a(n) ____.

equality join

Which of the following types of joins is created by matching equivalent values in each table

equality join

Data stored in separate tables can be reconstructed through the use of ____________________.

joins

Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled THE WOK WAY TO COOK SELECT title FROM promotion WHERE retail BETWEEN minretail AND maxretail; SELECT title FROM promotion NATURAL JOIN books WHERE retail BETWEEN minretail AND maxretail; SELECT title FROM promotion JOIN books USING retail BETWEEN minretail AND maxretail; none of the above

none of the above

A self-join can only be specified in the FROM clause with the use of the JOIN...____________________ keywords

on

When two tables that share more than one common column are being joined, the JOIN...____________________ keywords are normally used in the FROM clause to join the tables.

using

Which of the following keywords is used to create a Cartesian join?

CROSS JOIN

When using the JOIN...ON keywords to join four tables, both keywords must be repeated four times.

False

A table alias is assigned in the FROM clause.

True

A join that is based upon data having equivalent data in common columns is known as a(n) ____________________ join.

equality

If a table alias is assigned in the SELECT clause, it must be used any time the table is referenced in that SQL statement.

False

If you are attempting to join two tables that have multiple common columns, which of the following JOIN keywords should be used to specify how the tables should be linked

JOIN...USING

A table alias cannot be assigned in the FROM clause if which of the following keywords is used to join tables?

NATURAL JOIN