Referring to the SQL Transformation: Which Statements Is Correct and True

Referring to the SQL Transformation: which statements is correct and true.

A) The SQL transformation in script mode can execute sql scripts containing individual select statements that return more than one record to the pipeline
B) The SQL transformation in query mode can execute multiple SQL statements where components of the SQL Statement can vary from one execution to the next
C) In PowerCenter 9 the SQL transformation, in query mode, can only be active
D) When you bind a parameter to an input port, you identify the port by name in the query. The SQL Editor encloses the name in exclamation question marks (!)