Multiple choice

Which of the following explains 'correlated subquery'?

  1. Query evaluated once for every row processed by the parent statement

  2. Query evaluated once for the entire parent statement

  3. Query that retrieves multiple columns but single row

  4. Query displaying one column and one row

  5. Query which retrieves multiple columns and multiple rows

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Yes, it is correct. The multiple subqueries can be combined to form a single query.

Keep practicing — related questions