Oracle Database Advanced PL SQL 12c 1z0 148

Question : 35 of 54

Marks: +1, -0

Examine this function body:

Which two headers will allow this function to compile successfully and take advantage of both invoker’s rights and function result caching? (Choose two.)

CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2 RESULT_CACHE RELIES_ON (departments) AUTHID CURRENT_USER IS date_hired DATE;
CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2RESULT_CACHE AUTHID CURRENT_USERIS date_hired DATE;
CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2 RESULT_CACHE AUTHID DEFINER IS date_hired DATE;
CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2 RESULT_CACHE RELIES_ON (employees) AUTHID CURRENT_USER IS date_hired DATE;
CREATE FUNCTION get_hire_date (emp_id NUMBER) RETURN VARCHAR2 AUTHID DEFINER IS date_hired DATE;

Validate

Go to Question:

Prev Question

Next Question