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 6089

What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)

Option A

It can recommend partitioning only on tables that have at least 10,000 rows.

Option B

It cannot generate recommendations that support multiple workload queries.

Option C

It can recommend only B-tree indexes and not bitmap or function-based indexes.

Option D

It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.

Correct Answer A,D
Explanation


Question ID 6090

What are the advantages of variable extent size support for large ASM files? (Choose two.)

Option A

It improves performance in the extended cluster configuration by reading from a local copy of an extent.

Option B

It improves resync operations when the disk comes online after being taken offline for maintenance purposes.

Option C

This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.

Option D

Fewer extent pointers are needed to describe the file and less memory is required to manage the extent maps in the shared pool.

Correct Answer C,D
Explanation

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