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?
SET
ORDER BY
RETRIEVE
WHERE
2:
Which of the following wildcard searches are valid for use in WHERE clauses?
LIKE 'widget'
LIKE NOT '%widget%'
LIKE 100%
LIKE '%a%b%c%d%e%'
3:
To delete data from specific columns in a row, which statement should you use?
DELETE
UPDATE
NULL
4:
Which of the following statements about primary keys is true?