Nesting SELECT Statements › Things to Remember about Subqueries › Review

Review

Fill in the blanks with the appropriate words or phrases:

1. A nested SELECT statement is also known as a ______.
2. A subquery is located in a ______ clause.
3. A subquery must be enclosed in ___________________.
4. You use the ______ predicate to retrieve rows based on the existence of rows in another table.
5. When using an EXISTS predicate, the outer SELECT statement and the subquery are linked by matching ______ in the WHERE clause in the subquery.
6. You can use an asterisk (*) in the subquery if you are using the ______ keyword.

To check your answers, see Review Answers for Chapter 7.