Macromedia ColdFusion MX 7 Certified Developer Study Guide

A1:

A, and B. dbtype is an attribute of the <cfquery> tag that is used to specify the type of query, and executionTime is not in the query object (it is returned as cfquery.executionTime).

A2:

C. Although the <cfoutput> group attribute can be used in conjunction with SQL GROUP BY operations, <cfoutput> GROUP and GROUP BY are not related (the latter is used when performing aggregate calculations).

A3:

D. Query of queries requires a NAME attribute to reference the resulting query variable and dbtype="query" to instruct ColdFusion to look for table names in available query variables.

A4:

A, B, C, and D. Any SQL statement can be passed to the database by using <cfquery>, provided that the designated driver can handle it.

Категории