Bird
0
0

Which of the following best describes a correlated subquery?

easy📝 Conceptual Q2 of 15
SQL - Subqueries
Which of the following best describes a correlated subquery?
AA subquery that is executed only once
BA subquery that does not depend on the outer query
CA subquery that returns multiple rows without conditions
DA subquery that references columns from the outer query
Step-by-Step Solution
Solution:

  1. Step 1: Identify correlation in subqueries

    A correlated subquery uses columns from the outer query in its WHERE or SELECT clause.

  2. Step 2: Differentiate from non-correlated subqueries

    Non-correlated subqueries run independently without referencing outer query columns.

  3. Final Answer:

    A subquery that references columns from the outer query -> Option D

  4. Quick Check:

    Correlated subquery = references outer query columns [OK]
Quick Trick: Correlation means subquery uses outer query columns [OK]
Common Mistakes:
MISTAKES
  • Confusing correlation with subquery independence
  • Assuming all subqueries are correlated
  • Ignoring column references in subquery

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Aggregate Functions - COUNT function behavior - Quiz 12easy GROUP BY and HAVING - GROUP BY single column - Quiz 4medium INNER JOIN - INNER JOIN syntax - Quiz 9hard INNER JOIN - INNER JOIN with ON condition - Quiz 4medium LEFT and RIGHT JOIN - LEFT JOIN vs RIGHT JOIN decision - Quiz 10hard Set Operations - EXCEPT (MINUS) for differences - Quiz 11easy Subqueries - Subquery with EXISTS operator - Quiz 10hard Table Constraints - Composite primary keys - Quiz 10hard Views - Updatable views and limitations - Quiz 14medium Views - Updatable views and limitations - Quiz 3easy