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. Scalar Subquery
B. Independent Subquery
C. Correlated Subquery
D. Static Subquery
Answer: Option C
Solution (By JKSSB Mock Tests)
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!