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-050





Question ID 1955

Evaluate the following function code:
CREATE FUNCTION get_dept_avg(dept_id NUMBER)
RETURN NUMBER
RESULT_CACHE RELIES_ON (EMPLOYEES)
IS
avgsal NUMBER(6);
BEGIN
SELECT AVG(SAU\RY)INTO avgsal
FROM EMPLOYEES
WHERE DEPARTMENTJD = dept_id;
RETURN avgsal; END get_dept_avg;
Which statement is true regarding the above function?
 

Option A

A.    The cached result becomes invalid when any structural change is done to the EMPLOYEES table.
 

Option B

B.    If the function execution results in an unhandled exception, the exception result is also stored in the cache.
 

Option C

C.    Each time the function is invoked in a different session, the current result in the result cache gets overwritten.
 

Option D

D.    If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.
 

Correct Answer A
Explanation


Question ID 1956

Following is the list of locations in random order where oranfstab can be placed.
1 ./etc/mtab
2 .$ORACLE_HOME/dbs/oranfstab
3 ./etc/oranfstab
What is the sequence in which Direct NFS will search the locations?
 

Option A

A.    1,2,3
 

Option B

B.    3,2, 1
 

Option C

C.    2,3, 1

 

Option D

D.    1,3,2

Correct Answer C
Explanation

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