Multiple choice technology databases

The two types of subqueries are:

  1. Single-row subquery, Double-row subquery

  2. Double-row subquery, Multiple-row subquery

  3. Multiple-row subquery

  4. Single-row subquery and Multiple subquery
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Subqueries are classified as single-row (return one row) or multiple-row (return multiple rows). This classification determines which operators you can use: single-row operators (=, >, <) vs multiple-row operators (IN, ANY, ALL). Option D is correct despite slightly awkward phrasing.

Keep practicing — related questions