“Correlated Subquery “ actual works

1.) (8 Points) Please describe, in a short 1-2 paragraph answer, just how a “Correlated Subquery “ actual works. How does the inner query interact with the outer query? Just how many times does the inner query actually execute, etc.

2.) (8 Points) Explain how ‘EXISTS’ works with Subqueries.

3.) (8 Points) Which is better, joins or Subqueries? Maybe give some advantages and disadvantages of each…

4.) (8 Points) Please explain how ‘any’ and ‘all’ maybe used with subqueries.

5.) (8 Points) Can Subqueries be used in Inserts, Deletes and/or Updates? Please explain.

Sample Solution