Question 1

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

The inner join compares the tables in the FROM clause and retrieves only those rows that satisfy the condition mentioned in the WHERE clause. It returns only the matching rows from both the tables. The outer join, on the other hand, includes all the rows from one table and only matching rows from the other table, if any. The nested and product joins are not standard types of joins.

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, regardless of whether they have matching rows in the table on the left.

Question 3

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 4

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 5

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 6

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 both Oracle and SQL Server support it. The other operators listed (UNION, MINUS, ALL) are supported by all three database management systems.

Question 7

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 8

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 9

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 returns all rows from both tables and includes NULL values if a match is not found in one of the tables.

Question 10

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

To combine the results of two or more SELECT statements without returning duplicate rows and it is the primary functionality of UNION operation. Removing duplicate rows is necessary to avoid redundant data entries in the final result set.

Question 11

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

In a left outer join, all rows from the table on the left are included regardless of whether they match rows from the table on the right. Additionally, any matching rows from the table on the right will also be included in the result set. This type of join is useful when you want to include all records from one table, and only matching records from the second table.

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

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

Question 15

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

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

Question 16

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 17

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 18

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

Accepted Answer

The product of two tables is formally called the Cartesian Product. It is also sometimes referred to as the cross product or cross join. This operation produces a new table that contains all possible combinations of rows from the original tables. Each row in the resulting table represents one possible combination of a row from the first table with a row from the second table.

Question 19

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 20

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 returned by the subquery. The condition will only be true if the value satisfies all values returned by the subquery.

Quiz 5: Multiple-Table Queries

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?

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.

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

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

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

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

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.

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

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

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

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

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

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.

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

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.

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

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

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.

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