ISM Chapter 12

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

>ALL

With a MERGE statement, a series of ___ actions can occur with a single SQL statement

DML

The ___ operator is used to determine whether a condition is present in a subquery

EXISTS

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

single-row

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

single-row

The > operator is referred to as a ___ operator

single-row

A complete query nested inside another query is called a(n) ____

subquery

The outer query receives its input from the ___

subquery

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

HAVING

Which comparison operator allows you to search for NULL values in a subquery?

IS NULL

Based on the contents of the CUSTOMERS table, which of the following SQL statements will display the customer# of all customers who were referred by the same individual that referred customer# 1003?

SELECT customer# FROM customers WHERE NVL(referred, 0) = (SELECT NVL(referred,0) FROM customers WHERE customer# = 1003);

Based on the contents of the CUSTOMERS table, which SQL statement will display the customers residing in the same state as customer#1013?

SELECT customer# FROM customers WHERE state = (SELECT state FROM customers WHERE customer#=1013);

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

all of the above (IN, ANY, ALL)

A subquery must include a(n) ___ clause

both a and b (SELECT and FROM)

Which of the following terms refers to a type of subquery that is processed, or executed, once for each row in the outer query?

correlated subquery