Why is it recommended that procedures be compiled after they are first created or when changes are made to the procedure code?

What will be an ideal response?


Student answers may vary but should be similar to the one below.
Procedures should be compiled when first created or changed to determine if syntax errors are present in the procedure.  If syntax errors occur, the procedure will not run.  This gives the developer an opportunity to correct the syntax errors before these errors are encountered by the user.

Computer Science & Information Technology

You might also like to view...

When you add a custom field to a query, you need to enter a(n) ________ after the field name

Fill in the blank(s) with correct word

Computer Science & Information Technology

Using the seek() functions in random access, a(n) ____________________ offset means move forward in the file.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

In ________, Excel maximizes the number of cells visible on the screen

A) Page Layout view B) Backstage view C) Chart styles D) Normal view

Computer Science & Information Technology

Define a method, and provide three examples.

What will be an ideal response?

Computer Science & Information Technology