Question 1

​The results of a subquery are passed back as input to the ____ query.

Accepted Answer

The results of a subquery are passed back as input to the outer query. This allows the outer query to use the results of the subquery in its calculations or filtering.

Question 2

​The > operator is referred to as a(n)____ operator.

Accepted Answer

The > operator compares two values and returns true if the left operand is greater than the right operand. It is used to filter data in a single row based on a condition. Therefore, it is a single-row operator. The other options mentioned are not valid operators.

Question 3

​The following SQL statement contains what type of subqueries?
SELECT isbn,title FROM books WHERE pubid =
(SELECT pubid FROM books WHERE title = 'SHORTEST POEMS')
AND retail-cost >
(SELECT AVG(retail-cost)FROM books);

Accepted Answer

The subqueries in the given SQL statement are single-row subqueries. The first subquery returns a single pubid value for the book titled 'SHORTEST POEMS', and the second subquery calculates the average retail cost, also returning a single value.

Question 4

A subquery,except one in the FROM clause,cannot contain a(n)____ clause.​

Accepted Answer

Subqueries, except those in the FROM clause (which are actually derived tables or subselects), cannot contain an ORDER BY clause. The ORDER BY clause is used to sort the result set of a query by one or more columns and is typically used in the outermost SELECT statement. The purpose of a subquery is to return data to the enclosing query, and ordering this data inside the subquery usually has no effect on the final result of the main query, hence it's not allowed. Exceptions exist when using certain clauses like TOP or LIMIT within the subquery, but generally, ORDER BY is not used within subqueries.

Question 5

Which of the following operators is used with a multiple-row subquery?​

Accepted Answer

All of the options (IN, ANY, ALL) are operators that can be used with multiple-row subqueries in SQL. Each serves a different purpose when dealing with a set of values returned by a subquery.

Question 6

The operators =,<,>,<=,>=,and <> are referred to as ____ operators.

Accepted Answer

The operators =,<,>,<=,>=,and <> are referred to as single-row operators. These operators are used to compare a single row of data with a single value or another row of data.

Question 7

The <> operator is referred to as a(n)____ operator.​

Accepted Answer

The <> operator is a single-row operator used to compare two values in SQL, typically to check if they are not equal.

Question 8

A(n)____ subquery is one that can return several rows of results.​

Accepted Answer

A multiple-row subquery is one that returns more than one row of results. Correlated and uncorrelated refer to whether the subquery references data from the outer query, and single-row refers to a subquery that returns only one row of results.

Question 9

Which operators can be combined with other comparison operators to treat the results of a subquery as a set of values,rather than as individual values?​

Accepted Answer

The answer of Which operators can be combined with other...

Question 10

Which operator will instruct Oracle12c to list all records with a value that is more than the highest value returned by the subquery?

Accepted Answer

The operator >ALL will instruct Oracle12c to list all records with a value that is more than the highest value returned by the subquery.

Question 11

The following SQL statement contains which type of subquery?
SELECT title,retail, (SELECT AVG(retail)FROM books)
FROM books;​

Accepted Answer

The subquery `(SELECT AVG(retail) FROM books)` returns a single value (the average retail price of all books), making it a single-row subquery.

Question 12

A subquery must include a(n)____ clause.​

Accepted Answer

Subqueries must include both a SELECT clause to specify what data to retrieve and a FROM clause to specify from which table to retrieve the data.

Question 13

The = operator is referred to as a(n)____ operator.​

Accepted Answer

The = operator is referred to as a single-row operator because it is used to compare a single value from one row of a table to a single value or a single value expression.

Question 14

The ____ operator indicates that the records processed by the outer query must match one of the values returned by the subquery.​

Accepted Answer

The IN operator is used to check if a value matches any value in a list or subquery. It is typically used with a subquery, which returns a list of values to match against.

Question 15

The >ALL operator indicates that a value must be ____ value returned by the subquery.query?

Accepted Answer

The >ALL operator requires that a value be greater than every value returned by the subquery, which means it must be more than the highest value.

Question 16

The following SQL statement contains which type of subquery?
SELECT title,retail,category FROM books
WHERE retail IN (SELECT MAX(retail)FROM books
GROUP BY category);

Accepted Answer

The subquery in this SQL statement returns multiple rows (the maximum retail price for each category), hence it is a multiple-row subquery.

Question 17

The <= operator is referred to as a(n)____ operator.​

Accepted Answer

The <= operator is a comparison operator that is used to compare the values of two operands. It is a single-row operator as it compares values within a single row of data.

Question 18

​Which clause is used when the group results of a subquery need to be restricted,based on some condition?

Accepted Answer

The HAVING clause is used to restrict the results of a GROUP BY clause based on some condition. The WHERE clause is used to filter the results of a query before they are grouped or aggregated. The GROUP BY clause is used to group the results of a query by one or more columns. The ORDER BY clause is used to sort the results of a query in ascending or descending order based on one or more columns.

Question 19

If the result returned from a subquery must be compared to a group function,then the inner query must be nested in the outer query's ____ clause.​

Accepted Answer

When comparing a result returned from a subquery to a group function, the comparison must be done in the HAVING clause. The HAVING clause is used to filter group results after they have been computed by the GROUP BY clause.

Question 20

Which of the following must be used to separate a subquery from the outer query?​

Accepted Answer

A subquery must be enclosed within parentheses to differentiate it from the outer query.

Quiz 12: Subqueries and Merge Statements

The results of a subquery are passed back as input to the ____ query.

The > operator is referred to as a(n) ____ operator.

The following SQL statement contains what type of subqueries? SELECT isbn,title FROM books WHERE pubid = (SELECT pubid FROM books WHERE title = 'SHORTEST POEMS') AND retail-cost > (SELECT AVG(retail-cost) FROM books) ;

A subquery,except one in the FROM clause,cannot contain a(n) ____ clause.

Which of the following operators is used with a multiple-row subquery?

The operators =,<,>,<=,>=,and <> are referred to as ____ operators.

The <> operator is referred to as a(n) ____ operator.

A(n) ____ subquery is one that can return several rows of results.

Which operators can be combined with other comparison operators to treat the results of a subquery as a set of values,rather than as individual values?

Which operator will instruct Oracle12c to list all records with a value that is more than the highest value returned by the subquery?

The following SQL statement contains which type of subquery? SELECT title,retail, (SELECT AVG(retail) FROM books) FROM books;

A subquery must include a(n) ____ clause.

The = operator is referred to as a(n) ____ operator.

The ____ operator indicates that the records processed by the outer query must match one of the values returned by the subquery.

The >ALL operator indicates that a value must be ____ value returned by the subquery.query?

The following SQL statement contains which type of subquery? SELECT title,retail,category FROM books WHERE retail IN (SELECT MAX(retail) FROM books GROUP BY category) ;

The <= operator is referred to as a(n) ____ operator.

Which clause is used when the group results of a subquery need to be restricted,based on some condition?

If the result returned from a subquery must be compared to a group function,then the inner query must be nested in the outer query's ____ clause.

Which of the following must be used to separate a subquery from the outer query?

Quiz 12: Subqueries and Merge Statements

​The results of a subquery are passed back as input to the ____ query.

​The > operator is referred to as a(n) ____ operator.

​The following SQL statement contains what type of subqueries? SELECT isbn,title FROM books WHERE pubid = (SELECT pubid FROM books WHERE title = 'SHORTEST POEMS') AND retail-cost > (SELECT AVG(retail-cost) FROM books) ;

A subquery,except one in the FROM clause,cannot contain a(n) ____ clause.​

Which of the following operators is used with a multiple-row subquery?​

The operators =,<,>,<=,>=,and <> are referred to as ____ operators.​

The <> operator is referred to as a(n) ____ operator.​

A(n) ____ subquery is one that can return several rows of results.​

Which operators can be combined with other comparison operators to treat the results of a subquery as a set of values,rather than as individual values?​

Which operator will instruct Oracle12c to list all records with a value that is more than the highest value returned by the subquery?

The following SQL statement contains which type of subquery? SELECT title,retail, (SELECT AVG(retail) FROM books) FROM books;​

A subquery must include a(n) ____ clause.​

The = operator is referred to as a(n) ____ operator.​

The ____ operator indicates that the records processed by the outer query must match one of the values returned by the subquery.​

The >ALL operator indicates that a value must be ____ value returned by the subquery.query?

The following SQL statement contains which type of subquery? SELECT title,retail,category FROM books WHERE retail IN (SELECT MAX(retail) FROM books GROUP BY category) ;

The <= operator is referred to as a(n) ____ operator.​

​Which clause is used when the group results of a subquery need to be restricted,based on some condition?

If the result returned from a subquery must be compared to a group function,then the inner query must be nested in the outer query's ____ clause.​

Which of the following must be used to separate a subquery from the outer query?​

The results of a subquery are passed back as input to the ____ query.

The > operator is referred to as a(n) ____ operator.

The following SQL statement contains what type of subqueries? SELECT isbn,title FROM books WHERE pubid = (SELECT pubid FROM books WHERE title = 'SHORTEST POEMS') AND retail-cost > (SELECT AVG(retail-cost) FROM books) ;

A subquery,except one in the FROM clause,cannot contain a(n) ____ clause.

Which of the following operators is used with a multiple-row subquery?

The operators =,<,>,<=,>=,and <> are referred to as ____ operators.

The <> operator is referred to as a(n) ____ operator.

A(n) ____ subquery is one that can return several rows of results.

Which operators can be combined with other comparison operators to treat the results of a subquery as a set of values,rather than as individual values?

The following SQL statement contains which type of subquery? SELECT title,retail, (SELECT AVG(retail) FROM books) FROM books;

A subquery must include a(n) ____ clause.

The = operator is referred to as a(n) ____ operator.

The ____ operator indicates that the records processed by the outer query must match one of the values returned by the subquery.

The <= operator is referred to as a(n) ____ operator.

Which clause is used when the group results of a subquery need to be restricted,based on some condition?

If the result returned from a subquery must be compared to a group function,then the inner query must be nested in the outer query's ____ clause.

Which of the following must be used to separate a subquery from the outer query?