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 2799

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_hired
FROM 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.)
 

Option A

A. Set the RESULT_CACHE_MODE parameter to FORCE.
 

Option B

B.    Increase the value for the RESULT_CACHE_MAX_SIZE parameter.
 

Option C

C.    Add a format mask parameter, such as RETURN TO_CHAR(date_hired, fmt) to GET_HIRE_DATE.
 

Option D

D.    Change the return type of GET_HIRE_DATE to DATE and have each session invoke the TO_CHAR function.
 

Correct Answer C,D
Explanation


Question ID 2800

You designed a CardValidation.java Java source file. You also have the corresponding CardValidation.class file. As part of invoking a Java class method, you executed this command at the command prompt:
loadjava -user oe/oe CardValidation.java Which statement is true about the command?
 

Option A

A.    It loads the Java code into the database.
 

Option B

B.    It publishes Java methods in CardValidation.java.
 

Option C

C.    It loads the metadata related to the Java class file into the database.
 

Option D

D.    It loads the Java class file into the Java pool in the database instance.
 

Correct Answer A
Explanation

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