6.5. Review Questions

  1. A subquery is allowed in which parts of a SQL SELECT statement?

  2. True or false: A correlated subquery references a table in the SELECT clause.

  3. Which set operator will not remove duplicate rows from the result of a compound query?

  4. What characteristics of the columns in a compound query using INTERSECT must match?

  5. How are NULL values handled using set operators in a compound UNION query?

  6. Why are ROLLUP and CUBE the preferred methods for generating subtotals and grand totals for an aggregate query?

  7. Which operators can be used to compare a column to a single-row subquery?

  8. A compound query that needs to find only the rows that are the same between the two queries should use the __________ set operator.

  9. True or false: The IN operator ...

Get Oracle Database Foundations now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial