Oracle
1Z0-146 · Question #130
1Z0-146 Question #130: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #130. 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; Which statement is true in this scenario?
Options
- AIf sessions have different NLS_DATE_FORMAT settings, cached results have different formats.
- BThe function results are not cached because the query used in the function returns the DATE data type.
- CIf sessions have different NLS_DATE_FORMAT settings, cached results have same formats because
- DIf a function is executed with same argument value but different NLS_DATE_FORMAT for the session,
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.