Correct answer: A. A subquery that returns exactly one value
Explanation
A scalar subquery returns exactly one value (one row, one column) and can be used anywhere a single value is expected.
Practise 3 questions on this topic
Take SQL Subqueries — Timed Test (3 questions) — scored instantly, explanation for every question, no login.