SAP
C_TADM51_74 · Question #103
Oracle database release 10g is able to use new database statistic features for tables and index. Which statement regarding CBO (Cost-based optimizer) and RBO (Rule-based optimizer) is true? There…
The correct answer is A. Database statistics can be managed automatically in Oracle 10g. This is implemented in the B. Oracle 10g only supports CBO, while the RBO is not supported anymore. C. As of Oracle 10g, you are required to create statistics for the Oracle dictionary as well. See the full explanation below for the reasoning.
Question
Oracle database release 10g is able to use new database statistic features for tables and index. Which statement regarding CBO (Cost-based optimizer) and RBO (Rule-based optimizer) is true? There are 3 correct answers to this question.
Options
- ADatabase statistics can be managed automatically in Oracle 10g. This is implemented in the
- BOracle 10g only supports CBO, while the RBO is not supported anymore.
- CAs of Oracle 10g, you are required to create statistics for the Oracle dictionary as well.
- DIn Oracle 10g, both CBO- and RBO-based index statistics can be used simultaneously.
How the community answered
(26 responses)- A73% (19)
- D27% (7)
Community Discussion
No community discussion yet for this question.