Examine the following partial code:
Which statement is correct about the unnamed block of code at the end of a package body?
A.
It generates an error because all the blocks of code in a package body must be named.
B.
It generates an error because V_TAXRATE is a public variable that is already initialized in the
package specification.
C.
It acts as a package initialization block that executes once, when the package is first invoked
within the user session.
D.
It acts as a package initialization block that executes each time a package subprogram is
invoked within the user session and refreshes the initialized variablevalue.
C
C
c
C
A is incorrect. The CURSOR FOR LOOP will automatically terminate when all of the records in the cursor have been fetched. With each iteration, the cursor FOR LOOP statement fetches a row from the result set into the record. When there are no more rows to fetch, the cursor FOR LOOP statement closes the cursor.
The body holds implementation details and private declarations, which are hidden from code outside the package. Following the declarative part of the package body is the optional initialization part, which holds statements that initialize package variables and do any other one-time setup steps.
the body can have an initialization part, whose statements initialize public variables and do other one-time setup steps. The initialization part runs ONLY THE FIRST time the package is referenced. The initialization part can include an exception handler.