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?

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?
A. Add a parameter, fmt, and change the RETURN statement to: RETURN TO_CHAR (date_hired, fmt);
B. Set the RESULT_CACHE_MODE parameter to FORCE.
C. Increase the value for the RESULT_CACHE_MAX_SIZE parameter.
D. Change the return type of GET_HIRE_DATE to DATE and have each session invoke the TO_CHAR function.
E. Set the RESULT_CACHE_MAX_RESULT parameter to 0.

Download Printable PDF. VALID exam to help you PASS.