Menu
Home / CSE / Database System 2 - CS :: Discussion

Discussion :: Database System 2 - CS

  1. Which of the following is a correlated subquery?

    2. A.

     Uses the result of an inner query to determine the processing of an outer query.
    B.

     Uses the result of an outer query to determine the processing of an inner query.
    C.

     Uses the result of an inner query to determine the processing of an inner query.
    D.

     Uses the result of an outer query to determine the processing of an outer query.

    View Answer

    Workspace

    View Answer

    Answer : Option B

    Explanation :

    Correlated subquery references a column in the outer query and executes the subquery once for every row in the outer query while Uncorrelated subquery executes the subquery first and passes the value to the outer query.

Write your comments here:

Be The First To Comment