Oracle Database Administration II 1z0-083 Question # 15 Topic 2 Discussion

Oracle Database Administration II 1z0-083 Question # 15 Topic 2 Discussion

1z0-083 Exam Topic 2 Question 15 Discussion:
Question #: 15
Topic #: 2

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


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.


Get Premium 1z0-083 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.