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

Summary

The basic SQL statements are SELECT, INSERT, UPDATE, and DELETE. These four statements, combined with features and functions to be reviewed in the next few chapters, account for the majority of SQL written by ColdFusion developers.

Sample Questions

1:Which of these keywords are used in SELECT statements?
  1. SET

  2. ORDER BY

  3. RETRIEVE

  4. WHERE

2:Which of the following wildcard searches are valid for use in WHERE clauses?
  1. LIKE 'widget'

  2. LIKE NOT '%widget%'

  3. LIKE 100%

  4. LIKE '%a%b%c%d%e%'

3:To delete data from specific columns in a row, which statement should you use?
  1. DELETE

  2. UPDATE

  3. NULL

4:Which of the following statements about primary keys is true?
  1. Primary keys are required.

  2. Primary keys may be made up of multiple columns.

  3. Primary keys may be updated.

  4. Primary keys are always numbers.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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