1. If introduced as follows, the subquery can return which of the values listed below? a

WHERE VendorID NOT IN (subquery)

a.	a single value
b.	a column of one or more rows
c.	a table
d.	a subquery cant be introduced in this way

2. If introduced as follows, the subquery can return which of the values listed below?

WHERE InvoiceTotal > ALL (subquery)

a.	a single value
b.	a column of one or more rows
c.	a table
d.	a subquery cant be introduced in this way

3. If introduced as follows, the subquery can return which of the values listed below?

WHERE (subquery)

a.	a single value
b.	a column of one or more rows
c.	a table
d.	a subquery cant be introduced in this way

4. If introduced as follows, the subquery can return which of the values listed below?

WHERE 2 < (subquery)

a.	a single value
b.	a column of one or more rows
c.	a table
d.	a subquery cant be introduced in this way

5. If introduced as follows, the subquery can return which of the values listed below?

SELECT (subquery)

a.	a single value
b.	a column of one or more rows
c.	a table
d.	a subquery cant be introduced in this way

6. If introduced as follows, the subquery can return which of the values listed below?

FROM (subquery)

a.	a single value
b.	a column of one or more rows
c.	a table
d.	a subquery cant be introduced in this way

7. A correlated subquery is one that

a.	is executed once for each row in the outer query
b.	uses correlation names for one or more of the tables in a join
c.	uses correlation names for the tables in the subquery
d.	uses correlation names for the tables in the outer query