AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


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)
_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?
 

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
Explanation


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
Explanation

Send email to admin@getfreedumps for new dumps request!!!