Oracle
1Z0-146 · Question #105
1Z0-146 Question #105: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #105. The question stem and answer options stay visible for context.
Question
The result cache is enabled for the database instance. Examine the following code for a PL/SQL function: CREATE OR REPLACE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR RESULT_CACHE RELIES_ON (HR.EMPLOYEES) IS date_hired DATE; BEGIN SELECT hire_date INTO date_hired FROM HR.EMPLOYEES WHERE EMPLOYEE_ID = emp_id; RETURN TO_CHAR(date_hired); END; You notice that results for the functions are not used effectively. What do you recommend for better utilization of the result cache? (Choose all that apply.)
Options
- ASet the RESULT_CACHE_MODE parameter to FORCE.
- BIncrease the value for the RESULT_CACHE_MAX_SIZE parameter.
- CAdd a format mask parameter, such as RETURN TO_CHAR(date_hired, fmt) to GET_HIRE_DATE.
- DChange the return type of GET_HIRE_DATE to DATE and have each session invoke the TO_CHAR
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.