Exam 5: Multiple-Table Queries

In small databases, there is a significant time difference between different query approaches.

In a full outer join, all rows from both tables will be included regardless of whether they match rows from the other table.

A join that compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause is called a(n) ____________________ join.

You create an alias by typing the name of the table, pressing the ____, and then typing the name of the alias.

The product of two tables is formally called the ____ Product.

To ensure that query results are listed in a desired order, use the ORDER BY clause.

It is permissable to qualify all column names in a query.

If you precede a subquery by the ____________________ operator, the condition is true only if it satisfies one or more values produced by the subquery.

One reason for using an alias is when you are joining a table to itself.

If the SQL implementation truly supports the union operation, it will remove any duplicate ____________________ automatically.

You can join tables by using a condition in the WHERE clause.

The product operation is commonly used.

If you precede the subquery by the ____ operator, the condition is true only if it satisfies any value (one or more) produced by the subquery.

In a ____, all rows from the table on the right will be included regardless of whether they match rows from the table on the left.

Occasionally, a self-join might involve the primary key of a table.

Two tables are ____________________ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths.

When a subquery involves a table listed in the outer query, the subquery is called a(n) ____ subquery.

The subquery that involves a table listed in the outer query is called a(n) ____________________ subquery.

In a multiple-table query, you list all the desired columns in the ____________________ clause and qualify any columns that appear in more than one table.

In a(n) ____ join, all rows from both tables are included regardless of whether they match rows from the other table.