Assignment: Assign #$12$

INSTRUCTIONS

$[40$ Points$]$

Answer the following questions:

$(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.

$(8$ Points$)$ Explain how $$EXISTS$$ works with Subqueries.

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

$(8$ Points$)$ Please explain how $$any$$ and $$all$$ maybe used with subqueries.

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