Exam 5: Multiple-Table Queries

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

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

When joining tables, it is always necessary to qualify a column name.

It is easy to create a product inadvertently by omitting the WHERE clause when you are attempting to join tables.

A subquery within a subquery is called a(n)____________________ subquery.

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

The product operation is commonly used.

To relate two tables, in the FROM clause list all columns involved in the query.

Which of the following set operators are not supported by MySQL?

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

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

The ____________________ of two tables is the combination of all rows in the first table and all rows in the second table.

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

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

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.

MySQL supports the INTERSECT operator.

What steps should you take to join (relate)tables?

You can use the EXISTS operator to retrieve data from more than one table.

A(n)____ clause can include statistics calculated for only the groups or columns whose values are identical for each row in a group.

To retrieve data from multiple tables in a query you can use the ____ operator with a subquery.