Question 1

When tables are listed in the FROM clause, you can give each table a(n)____________________, or an alternate name.

Accepted Answer

The answer of When tables are listed in the FROM...

Question 2

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).
A)left inner join
B)left outer join
C)right inner join
D)right outer join

Accepted Answer

The left outer join will include all rows from the table on the left (the first listed table in the query) regardless of whether they match rows from the table on the right. Any matching rows from the table on the right will also be included, but if there are no matches, the result will still include all rows from the left table.

Question 3

You join tables in SQL by including a condition in the ____________________ clause to ensure that matching columns contain equal values.

Accepted Answer

The answer of You join tables in SQL by including...

Question 4

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.
A)left inner join
B)left outer join
C)right outer join
D)right inner join

Accepted Answer

A right outer join includes all rows from the table on the right, regardless of whether they match rows from the table on the left.

Question 5

Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause?
A)inner
B)outer
C)nested
D)product

Accepted Answer

An inner join compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause. Outer joins return all or some of the rows from one or both tables depending on whether a row in one or both tables satisfies the join condition. Nested joins are not a type of join, but rather refer to using a subquery as a join condition. A product join (also known as a cartesian join or cross join) returns all possible combinations of rows from the tables in the FROM clause.

Question 6

The product of two tables is formally called the ____ Product.
A)Oracle
B)Outer
C)SQL
D)Cartesian

Accepted Answer

The Cartesian Product calculates the combination of all rows from both tables by matching each row of one table with every row of another table. It is also known as the Cross Join in SQL. The product of two tables is not formally called Oracle, Outer, or SQL Product.

Question 7

When there is potential ambiguity in listing column names, you must ____________________ the columns involved in the query.

Accepted Answer

The answer of When there is potential ambiguity in listing...

Question 8

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

Accepted Answer

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

Question 9

If you precede the subquery by the ____ operator, the condition is true only if it satisfies all values produced by the subquery.
A)TRUE
B)ALL
C)IS ALL
D)ALWAYS

Accepted Answer

The ALL operator is used to indicate that the condition must be satisfied by all values produced by the subquery.

Question 10

In a(n)____ join, all rows from both tables are included regardless of whether they match rows from the other table..
A)normal
B)inner
C)full outer
D)combined

Accepted Answer

A full outer join includes all rows from both tables, including those with no matching rows in the other table. Therefore, it is the best choice for this scenario.

Question 11

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.
A)IS SOME
B)IS ANY
C)SOME
D)ANY

Accepted Answer

The ANY operator is used to compare a value to any value returned by the subquery. It returns true if any of the values in the subquery return true, and false only if all the values in the subquery return false.

Question 12

Two tables are ____ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths.
A)union
B)minus
C)difference
D)intersect

Accepted Answer

The answer of Two tables are ____ compatible if they...

Question 13

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

Accepted Answer

The answer of The subquery that involves a table listed...

Question 14

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.

Accepted Answer

The answer of If you had two separate tables for...

Question 15

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

Accepted Answer

The answer of Joining a table to itself, is called...

Question 16

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.

Accepted Answer

The answer of In a multiple-table query, you list all...

Question 17

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

Accepted Answer

The answer of MySQL performs many built-in ____________________ that analyze...

Question 18

Which of the following set operators are not supported by MySQL?
A)UNION and MINUS
B)MINUS and INTERSECT
C)UNION and INTERSECT
D)UNION and ALL

Accepted Answer

MySQL does not support the MINUS and INTERSECT set operators. However, it does support UNION and ALL.

Question 19

For an SQL implementation to truly support the union operation, it must remove____ rows automatically..
A)dependent
B)no
C)independent
D)duplicate

Accepted Answer

The union operation combines the results of two or more select statements into a single result set that includes all the rows that belong to all select statements. Therefore, to avoid duplicates in the final result set, the SQL implementation must remove duplicate rows automatically.

Question 20

To retrieve data from more than one table, you must ____________________ the tables together by finding rows in the two tables that have identical values in matching columns.

Accepted Answer

The answer of To retrieve data from more than one...

Quiz 5: Multiple-Table Queries

When tables are listed in the FROM clause, you can give each table a(n)____________________, or an alternate name.

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) .

You join tables in SQL by including a condition in the ____________________ clause to ensure that matching columns contain equal values.

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.

Which of the following joins compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause?

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

When there is potential ambiguity in listing column names, you must ____________________ the columns involved in the query.

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

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

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

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.

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