Macromedia ColdFusion MX 7 Certified Developer Study Guide
A1:
A, D, and E. This is a trick question. Queries cannot be cached in CLIENT or COOKIE variables. They can, however, be stored in VARIABLES variables (in fact, that is what most queries are stored).
A2:
A and D. Query-based caching can be disabled in the ColdFusion Administrator, but there is no way to prevent users from caching queries to variables. Locking is an issue only with variable-based caching.
A3:
C. CACHEDWITHIN and CACHEDAFTER are used in query caching. Answer D does not exist.
A4:
D. Bind parameters will not allow extraneous characters in SQL statements.