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 2522

What are three common reasons for SQL statements to perform poorly?
 

Option A

A.    Full table scans for queries with highly selective filters
 

Option B

B.    Stale or missing optimizer statistics
 

Option C

C.    Histograms not existing on columns with evenly distributed data
 

Option D

D.    High index clustering factor

 

Option E

E.    OPTIMIZER_MODE parameter set to ALL_ROWS for DSS workload

Correct Answer A,B,D
Explanation


Question ID 2523

Examine the utilization parameters for an instance:
 
You notice that despite having an index on the column used in the where clause, queries use full table scans with highly selective filters.
What are two possible reasons for the optimizer to use full table scans instead of index unique scans and index range scans?

Option A

A.    The OPTIMIZER_MODE parameter is set to ALL_ROWS.
 

Option B

B.    The clustering factor for the indexes is high.
 

Option C

C.    The number of leaf blocks for the indexes is high.
 

Option D

D.    The OPTIMIZER_INDEX_COST_ADJ initialization parameter is set to 100.
 

Option E

E.    The blocks fetched by the query are greater than the value specified by the DB_FILE_MULTIBLOCK_READ_COUNT parameter.
 

Correct Answer A,B
Explanation

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