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