Free 1Z0-148 Web TestEngine Demo

Q20 Multiple choice

Examine this function body:

BEGIN
SELECT hire_date INTO date_hired FROM employees WHERE employee_id=emp_id;
RETURN TO_CHAR(date_hired);
END;

Which two headers will allow this function to compile successfully and take advantage of both invoker's rights and function result caching?

Select all that apply.

A
CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2
RESULT_CACHE RELIES_ON (departments)
AUTHID CURRENT_USER
IS
date_hired DATE;
B
CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2
RESULT_CACHE
AUTHID CURRENT_USER
IS
date_hired DATE;
C
CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2
RESULT_CACHE
AUTHID DEFINER
IS
date_hired DATE;
D
CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2
RESULT_CACHE RELIES_ON (employees)
AUTHID CURRENT_USER
IS
date_hired DATE;
E
CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2
AUTHID DEFINER
IS
date_hired DATE;

1Z0-148 Web TestEngine demo