CIST 1220: SQL Assign #12

(40 Points)

[More SubQueries Chap 8]

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.