When an SQL SELECT Command Has a Subquery Within It

Multiple Choice

When an SQL SELECT command has a subquery within it ____.

A) the subquery is executed first
B) the subquery is executed last
C) there is just one SELECT clause in the entire command, including the subquery
D) all predicates in the subquery's WHERE clause are passed back to the main query
E) all predicates in the main query's WHERE clause are passed down to the subquery