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. Static Subquery
B. Independent Subquery
C. Correlated Subquery
D. Scalar 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.
Explanation:
Databases are optimized for transaction processing (OLTP), while data warehouses are designed for analytical reporting (OLAP) using historical data.
No comments yet. Be the first to start the discussion!