• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part: 10 Appendix > Chapter 44

Chapter 44

A1: B and D. A is used in UPDATE operations. C is not a valid keyword.
A2: A and D. A is valid. Wildcard characters are actually not required when you use LIKE; the search is effectively an equality test. B is invalid; NOT must precede LIKE. C is invalid; wildcards can be used with strings, not with numbers. D is valid; there is no limit to the number of wildcard characters that you can use in a search.
A3: B. You use UPDATE when columns (as opposed to rows) are affected. A, DELETE, deletes entire rows. C, NULL, is not a statement; it represents no value and can be used with UPDATE to set a column to no value.
A4: B. Primary keys may indeed be made up of more than one column. All the other statements are false.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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