Question 1

Oracle and SQL Server support the ____ operator but Microsoft Access does not.
A) UNION
B) INTERSECT
C) MINUS
D) ALL

Accepted Answer

Microsoft Access does not support the INTERSECT operator, while Oracle and SQL Server do. The other operators listed (UNION, MINUS, ALL) are supported by all three database systems.

Question 2

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, and only matching rows from the table on the left. The other options (left inner join, left outer join, right inner join) either only include matching rows from both tables or only include all rows from the table on the left.

Question 3

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 4

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 compare a value to all values produced by a subquery, and the condition is true only if it matches all of them. Therefore, if you precede the subquery by the ALL operator, the condition is true only if it satisfies all values produced by the subquery.

Question 5

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 6

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 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

The Cartesian product of two tables is the result of matching each row of one table with every row of the other table. It is also known as a cross-join. Therefore, the best choice is D, Cartesian. The other options (A, Oracle and C, SQL) are not appropriate as they do not refer specifically to the product of two tables, and B, Outer, refers to a specific type of join operation rather than the product of two tables.

Question 9

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 (option B) return all rows from one table and the matching rows from another table, filling in missing information with nulls. Nested joins (option C) do not exist in SQL. Product joins (option D), also known as cartesian joins, return all possible combinations of rows from both tables, which can quickly become very large and inefficient.

Question 10

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 11

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, regardless of whether they have a matching row in the other table. This is different from an inner join, which only includes rows where there is a match in both tables. A normal join is not a commonly used term, and a combined join is not a standard type of join.

Question 12

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 13

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 14

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 15

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 16

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

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

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

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

SQL's default behavior for the union operation is to include all rows, including duplicates. However, if we want to remove duplicate rows, we can use the "DISTINCT" keyword or specify the "UNION ALL" operation. Therefore, the implementation must remove duplicate rows automatically to support the union operation fully.

Question 20

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

A left outer join includes all rows from the left table and only matching rows from the right table, while non-matching rows from the left table will have NULL values for the columns selected from the right table.

Quiz 5: Multiple-Table Queries

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

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.

The subquery that involves a table listed in the outer query 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.

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

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

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

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

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?

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.

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

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.

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

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.

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

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.

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

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

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

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