Question 1

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

Accepted Answer

A) intersect 
B) union 
C) difference 
D) minus

Question 2

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

Accepted Answer

A) Oracle 
B) Outer 
C) SQL 
D) Cartesian

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

The answer of A subquery within a subquery is called...

Question 6

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

Accepted Answer

A) union 
B) intersect 
C) intersection 
D) difference

Question 7

The product operation is commonly used.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) UNION and MINUS 
B) MINUS and INTERSECT 
C) UNION and INTERSECT 
D) UNION and ALL

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

The answer of The ____________________ of two tables is the...

Question 13

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

Accepted Answer

A) intersection 
B) union 
C) minus 
D) difference

Question 14

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

Accepted Answer

The answer of What steps should you do to construct...

Question 15

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.

Accepted Answer

The answer of A join that compares the tables in...

Question 16

MySQL supports the INTERSECT operator.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

The answer of What steps should you take to join...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) SELECT 
B) WHERE 
C) FROM 
D) EXISTS

Question 20

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

Accepted Answer

A) AND 
B) IN 
C) OR 
D) NOT

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.