Oracle Database Administration II — Question 61

Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

Answer options

• A. The number of table rows is considered when evaluating the cost of accessing a table using an index.
• B. Index balanced B*Tree height is considered when evaluating the cost of using an index.
• C. The Statistics Advisor can help recommend the best way to gather statistics.
• D. Statistics collected using DBMS_STATS always yield the best optimizer result.
• E. The Statistics Advisor generates actions for all recommendations.

Correct answer: C, D

Explanation

The correct answer is C because the Statistics Advisor provides insights on how to effectively gather statistics, which is crucial for optimization. D is incorrect because while DBMS_STATS is a powerful tool, it does not guarantee the best results in every scenario, as other factors can influence optimizer performance. The other options relate to considerations and capabilities that are not universally true about statistics gathering and optimization.