• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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?
  1. VARIABLES

  2. CLIENT

  3. COOKIE

  4. APPLICATION

  5. SERVER

2:Which of the following statements are true?
  1. Query-based caching can be disabled.

  2. Variable-based caching can be disabled.

  3. Query-based caching requires the use of locks.

  4. 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?
  1. cachedwithin

  2. cachedafter

  3. blockfactor

  4. packetsize

4:Which of the following technologies could be used to prevent database hacking via URL tampering?
  1. Caching

  2. Trigger

  3. Index

  4. Bind parameter


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint