Oracle
1Z0-050 · Question #54
What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.)
The correct answer is B. partitioning of tables and indexes D. creation of bitmap, function-based, and B-tree indexes E. optimization of materialized views for maximum query usage and fast refresh. See the full explanation below for the reasoning.
Question
What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.)
Options
- Aselection of SQL plan baselines
- Bpartitioning of tables and indexes
- Ccreation of index-organized tables
- Dcreation of bitmap, function-based, and B-tree indexes
- Eoptimization of materialized views for maximum query usage and fast refresh
How the community answered
(43 responses)- A5% (2)
- B84% (36)
- C12% (5)
Community Discussion
No community discussion yet for this question.