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





Question ID 2528

You are logged in as the HR user and you execute the following procedure:
SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘HR’, ‘EMPLOYEES’, ‘PUBLISH’, ‘FALSE’); SQL> exec DBMS_STATS.GATHER_TABLE_STATS (‘HR’, ‘EMPLOYEES’);
Which statement is true about the newly gathered statistics?
 

Option A

A.    They are temporary and purged when the session exits.
 

Option B

B.    They are used by the optimizer for all sessions.
 

Option C

C.    They are locked and cannot be overwritten.

 

Option D

D.    They are marked as pending and stored in the pending statistics table.

Correct Answer D
Explanation


Question ID 2529

You enable auto degree of parallelism (DOP) for your database instance.
Examine the following query:
 
Which two are true about the execution of statement?
 

Option A

A.    Dictionary DOP for the objects accessed by the query is used to determine the statement DOP.
 

Option B

B.    Auto DOP is used to determine the statement DOP only if the estimated serial execution time exceeds PARALLEL_MIN_TIME_THRESHOLD.
 

Option C

C.    Dictionary DOP is used to determine the statement DOP only if the estimated serial execution time exceeds PARALLEL_MIN_TIME_THRESHOLD.
 

Option D

D.    The statement will be queued if insufficient parallel execution slaves are available to satisfy the statements DOP.
 

Option E

E.    The statement will be queued if the number of busy parallel execution servers exceeds PARALLEL_SERVERS_TARGET.

 

Option F

F.    The statements may execute serially.

Correct Answer E,F
Explanation

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