Question: The difference between Correlated and non - correlated is / are Question 9 options: B . A non - Correlated subquery is faster than the
The difference between Correlated and noncorrelatedisare
Question options:
B A nonCorrelated subquery is faster than the correlated subquery, because a correlated inner subquery executes for each row of the outer query.
A A correlated subquery produces results independently of outer select, whereas non correlated subquery must have a value from the outer select before it executes.
Both B and C
C A non correlated subquery produces results independently of outer select, whereas correlated subquery must have a value from the outer select before it executes.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
