Exam 5: Multiple-Table Queries

There is only one approach to joining tables.

When the innermost subquery is evaluated, a permanent table is produced.

Table A has 10 rows and table B has 10 rows. The product of Table A and Table B would have 100 rows.

The ____ of two tables is a table containing every row that is in either the first table, the second table, or both tables.

SQL performs many built-in ____________________ that analyze queries to determine the best way to satisfy them.

You can use the ALL and ANY operators with subqueries to produce a single column of numbers.

In a ____, all rows from the table on the left (the table listed first in the query) will be included regardless of whether they match rows from the table on the right (the table listed second in the query).

The ____________________ of two tables is a table containing every row that is in either the first table, the second table, or both tables.

You can use the IN operator to retrieve data from multiple tables..

To qualify a column name, precede the name of the column with the name of the table, followed by a(n) ____.

If you precede the subquery by the ____ operator, the condition is true only if it satisfies all values produced by the subquery.

What steps should you take to construct a detailed query in a step-by-step fashion?

Oracle and SQL Server support the ____ operator but Microsoft Access does not.

The ____________________ of two tables is the set of all rows that are in the first table but that are not in the second table.

You must use a comma or a period to separate a table name from its alias.

When using a DBMS without an optimizer, the formulation of a query can make a difference in the speed with which the query is executed..

Sometimes you need to list all the rows from one of the tables in a join, regardless of whether they match any rows in the other table. This type of join is called a(n) ____________________ join.

The ____ of two tables is a table containing all rows that are in both tables.

Describe the types of outer joins.

For an SQL implementation to truly support the union operation, it must remove ____ rows automatically.