Oracle Database Advanced PL SQL 12c 1z0 148

Question : 25 of 54

Marks: +1, -0

This result cache is enabled for the database instance
Examine this code for a PL/SQL function:

Which two actions would ensure that the same result will be consistently returned for any session when the same input value is passed to the function? (Choose two.)

Add a parameter, fmt, and change the RETURN statement to:
RETURN TO_CHAR (date_hired, fmt);
Set the RESULT_CACHE_MODE parameter to FORCE.
Increase the value for the RESULT_CACHE_MAX_SIZE parameter
Change the return type of GET_HIRE_DATE to DATE and have each session invoke the TO_CHAR function
Set the RESULT_CACHE_MAX_RESULT parameter to 0.

Validate

Go to Question:

Prev Question

Next Question