Summary

Database response and access times play a pivotal role in the performance of ColdFusion applications. Most performance issues are caused by bad SQL, poor database design, and other fundamental database-related concerns. But in addition to those, eliminating unnecessary database and network load can help application performance, and ColdFusion provides the mechanisms to accomplish this.

Sample Questions

1:	Database queries can be cached into which of the following scopes? VARIABLES CLIENT COOKIE APPLICATION SERVER
2:	Which of the following statements are true? Query-based caching can be disabled. Variable-based caching can be disabled. Query-based caching requires the use of locks. Variable-based caching requires the use of locks.
3:	Which <cfquery> attribute is used to reduce the number of round-trips to the database server during data retrieval? cachedwithin cachedafter blockfactor packetsize
4:	Which of the following technologies could be used to prevent database hacking via URL tampering? Caching Trigger Index Bind parameter