READ Free Dumps For Oracle- 1z0-146
Question ID 2859 | 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) |
Option A | A. If sessions have different NLS_DATE_FORMAT settings, cached results have different formats. |
Option B | B. The function results are not cached because the query used in the function returns the DATE data type. |
Option C | C. If sessions have different NLS_DATE_FORMAT settings, cached results have same formats because the function's return type is VARCHAR. |
Option D | D. If a function is executed with same argument value but different NLS_DATE_FORMAT for the session, the cached result is overwritten with the new function result. |
Correct Answer | A |
Question ID 2860 | Which two statements are true about associative arrays and nested tables? (Choose two.) |
Option A | A. Only associative arrays can hold an arbitrary number of elements. |
Option B | B. Only nested tables can be used as column types in database tables. |
Option C | C. Both associative arrays and nested tables can hold an arbitrary number of elements. |
Option D | D. Both associative arrays and nested tables can be used as column types in database tables. |
Correct Answer | B,C |