What is a correlated sub query?

Options
- The result retrieved by the inner query is fed to the outer query
- a correlated sub-query is dependent upon the outer query
- The outer query gives a reference to the sub query
- Both a and b


CORRECT ANSWER : a correlated sub-query is dependent upon the outer query

Discussion Board
Correlated sub-query

A correlated sub-query is dependent upon the outer query. A correlated sub-query (also known as a synchronized sub-query) is a sub-query (a query nested inside another query) that uses values from the outer query. Because the sub-query is evaluated once for each row processed by the outer query, it can be inefficient.

Prajakta Pandit 02-10-2017 12:51 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement