Which type of subquery executes once for each row evaluated by the outer query, depending on values provided by the outer statement? MCQ with Answer and Explanation
Which type of subquery executes once for each row evaluated by the outer query, depending on values provided by the outer statement?
A. Correlated Subquery
B. Static Subquery
C. Independent Subquery
D. Scalar Subquery
Answer: Option A
Solution (By JKExamLibrary)
A Correlated Subquery is an inner query that references columns from the outer query, meaning it must be executed repeatedly for each row evaluated by the outer query.
No comments yet. Be the first to start the discussion!