Exam 5: Multiple-Table Queries

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

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

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

Joining a table to itself, is called a(n)____________________.

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

If you had two separate tables for customers and the query requested customers in the first table having the same city as customers in the second table, you could use a normal ____________________ operation to find the answer.

You can use MySQL to create a nested subquery.

For two tables to be union compatible, the columns of the two tables must be identical.

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

You can perform special operations within SQL.

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

You can join three tables together but not four tables.

To produce the same results as the INTERSECT operator, use the BETWEEN operator and a subquery.

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.