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

Part: 10 Appendix > Chapter 23

Chapter 23

A1: A, B, and D. Stored procedures are much faster than passing SQL or calling a view because they are precompiled in the database server. Therefore, A is correct. B is also correct, because stored procedures can hide certain columns and introduce layers of abstraction. D is correct, as stored procedures are indeed more powerful. C and E are not correct, because stored procedures can be difficult to create and are not standard across database platforms.
A2: C. The TYPE attribute of <cfprocparam> is "inout" when a stored procedure gives a variable the same name as that of the parameter it returns. An example would be a stored procedure that takes a product's price (itemPrice) and returns the price (again as itemPrice), with all discounts applied.
A3: B. <cfprocparam> can return arrays, but <cfprocresult> always returns queries.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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