Multiple Choice
All of the following represent restrictions on functions, except ____.
A) Functions cannot modify any tables in Oracle8i and prior versions.
B) Functions cannot be used in a CHECK constraint or as a default value of a table column.
C) If used in a remote or parallel operation, no reading or writing of packaged variables is allowed.
D) If used in a SELECT,VALUES, or SET clause, the function cannot write values to packaged variables.
Correct Answer:

Verified
Correct Answer:
Verified
Q57: The <u>AUTHID</u> directive needs to be included
Q58: _ can be created only as stored
Q59: A REEF CURSOR data type declared in
Q60: The _ data dictionary view allows us
Q61: The <u>USER_OBJECTS</u> data dictionary view allows us
Q63: The term _ in packages refers to
Q64: When compiling objects that call packaged program
Q65: When compiling objects that call packaged program
Q66: The _ directive needs to be included
Q67: Packages can be created in local libraries,