In which scenario is a correlated subquery typically less efficient than a JOIN?
Answer options
A
When the subquery returns a single value
B
When the outer query has very few rows
C
When the subquery executes once for each row of the outer query on a large table
D
When used with EXISTS on an indexed column
Correct answer: When the subquery executes once for each row of the outer query on a large table
Explanation
Quick AnswerThe correct answer is When the subquery executes once for each row of the outer query on a large table because it directly addresses the core logic of Database Management.
This question has been retained as-is due to its unique context.