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.