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?

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?

Accepted Answer

A. If sessions have different NLS_DATE_FORMAT settings, cached results have different formats.

Answer

B. The function results are not cached because the query used in the function returns the DATE data type.

Answer

C. If sessions have different NLS_DATE_FORMAT settings, cached results have same formats because

Answer

D. If a function is executed with same argument value but different NLS_DATE_FORMAT for the session,

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…

Question

Options

How the community answered

Community Discussion