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
Q36: CREATE OR REPLACE PACKAGE metric_pkg IS cup_to_liter
Q37: Full procedures or function codes are contained
Q38: The AUTHID directive needs to be included
Q39: The USER_SOURCE data dictionary view is useful
Q40: The _ is referred to as the
Q42: The term _ in packages refers to
Q43: When compiling objects that call packaged program
Q44: CREATE OR REPLACE PACKAGE product_info_pkg IS PROCEDURE
Q45: Which of the following correctly sets the
Q46: All of the following represent packaged function
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents