Which two statements are true about cursor variables? (Choose two.)
View Exhibit1 and examine the structure of the EMPLOYEES and DEPARTMENTS tables existing in your schema. View Exhibit2 and examine the PL/SQL block that you execute to display the department-wise incremented salary for all the departments in your company. The code generates an error on execution. What correction should be done to ensure the code executes successfully?
Which two statements are true about SecureFile LOB options? (Choose two.)
Identify two factors that you consider for compiling a PL/SQL program unit for interpreted mode. (Choose two.)
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_hiredFROM 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.)
Examine the settings for a user session given below: RESULT_CACHE_MODE= FORCE What would be the implications of this setting on query execution?(Choose all that apply.)
