| 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
|
|