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

Summary

Stored procedures are precompiled SQL statements that are stored in a database and executed at run time. Each database has its own stored procedure syntax that can be sent from ColdFusion using a <cfquery>. A more powerful interface for stored procedures is the <cfstoredproc> tag. This tag has an end tag and takes two possible nested tags: <cfprocparam> and <cfprocresult>. <cfprocparam> can send and receive parameters, whereas <cfprocresult> was built to expose result sets as ColdFusion record sets.

Sample Questions

1:Why are stored procedures better than views or queries? (Choose all that apply)
  1. They execute faster.

  2. They are more secure.

  3. They are easier to create.

  4. They are more powerful.

  5. They work with all databases.

2:When should the type attribute of the <cfprocparam> tag be set to inout?
  1. A parameter needs to be sent back from a stored procedure only.

  2. A parameter is sent to a stored procedure and a different parameter is returned.

  3. A parameter of the same name is sent and received from the stored procedure.

  4. A stored procedure optionally accepts parameters.

3:<cfprocresult> returns what type of data?
  1. Structure of arrays

  2. Queries

  3. Arrays

  4. Simple data


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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