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 2504

Examine Exhibit1 to view the query and its AUTOTRACE output.
 
 
Which two statements are true about tracing?

Option A

A.    The displayed plan will be stored in PLAN_TABLE.
 

Option B

B.    Subsequent execution of this statement will use the displayed plan that is stored in v$SQL.
 

Option C

C.    The displayed plan may not necessarily be used by the optimizer.
 

Option D

D.    The query will not fetch any rows; it will display only the execution plan and statistics.

 

Option E

E.    The execution plan generated can be viewed from v$SQLAREA.

Correct Answer A,D
Explanation


Question ID 2505

Which two types of column filtering may benefit from partition pruning?
 

Option A

A.    Equally operates on range-partitioned tables.
 

Option B

B.    In-list operators on system-partitioned tables
 

Option C

C.    Equality operators on system-partitioned tables
 

Option D

D.    Operators on range-partitioned tables

 

Option E

E.    Greater than operators on hash-partitioned tables

Correct Answer A,D
Explanation

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