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

The SQL transformation in script mode can execute sql scripts containing individual select statements that return more than one record to the pipeline

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

In PowerCenter 9 the SQL transformation, in query mode, can only be active

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 (!)