Sams Teach Yourself ColdFusion® in 21 Days

Day 19

Quiz

1:	Name at least three control characters that can give ColdFusion problems when used in variable names.
A1:	You could have listed any of these: a space, ", ', -, or #.
2:	When defining column aliases, what character is used to delimit the original field name?
A2:	The backtick, or "`" character .
3:	Name the two types of SQL functions. One of them isn't discussed in this book. Why?
A3:	The two types of SQL functions are aggregate and scalar. SQL's Scalar functions aren't discussed in this book because almost all of them can be duplicated with the standard ColdFusion functions .
4:	Why is it preferable to relate two database tables by a numeric field such as ID instead of a text field?
A4:	Because SQL is more efficient at searching numeric ...