Multiple choice technology databases

Single-row subquery returns:

  1. Only one row

  2. Two rows

  3. Zero rows

  4. There is no such subquery
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A single-row subquery is designed to return exactly one row from the inner query. This type of subquery can be used with single-row comparison operators like =, >, <, etc. Options B and C are incorrect because they describe multi-row or no-row scenarios, while D is false as single-row subqueries are a valid SQL construct.

Keep practicing — related questions