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.



Macromedia ColdFusion MX 7 Certified Developer Study Guide
Macromedia ColdFusion MX 7 Certified Developer Study Guide
ISBN: 0321330110
EAN: 2147483647
Year: 2004
Pages: 389
Authors: Ben Forta

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net