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

Day 5

Quiz

1: What ColdFusion tags denote the beginning and end of a query section?
A1: <CFQUERY> and </CFQUERY>, respectively
2: In a basic SQL SELECT statement, what follows the word "FROM"?
A2: The name of the table we want to query
3: What are the two types of operators used in a WHERE clause?
A3: Relational operators and logical operators
4: Why are single quotes necessary when using a text string in a query?
A4: Single quotes identify the beginning and end of the text string and tell ColdFusion that the contents are to be evaluated as text. Occasionally, text strings contain characters that might otherwise be identified as special control characters, such as the equal sign or a comma.
5: What is the character that always appears in conjunction with the LIKE operator?
A5: The percent sign (%) always appears with the LIKE operator.
6: Which SQL command orders output alphabetically or numerically? How is it used?
A6: The ORDER BY command sorts output data by letter or number. It is placed at the end of a query, followed by a comma-delimited list of the fields by which to sort.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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