SAP
C_TADM51_70 · Question #38
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?(Choose…
The correct answer is B. Database statistics can be managed automatically in Oracle 10g. This is implemented in the database as C. Oracle 10g only supports CBO, while the RBO is not supported anymore. D. 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?(Choose three.)
Options
- AIn Oracle 10g, both CBO- and RBO-based index statistics can be used simultaneously.
- BDatabase statistics can be managed automatically in Oracle 10g. This is implemented in the database as
- COracle 10g only supports CBO, while the RBO is not supported anymore.
- DAs of Oracle 10g, you are required to create statistics for the Oracle dictionary as well.
How the community answered
(44 responses)- A23% (10)
- B77% (34)
Community Discussion
No community discussion yet for this question.