Oracle
1Z0-417 · Question #28
SQL Access Advisor takes database workload as input and recommends adding various access structures. Which three does it consider the impact of adding when it generates recommendations?
The correct answer is A. Materialized views B. Indexes C. Partitions. See the full explanation below for the reasoning.
Question
SQL Access Advisor takes database workload as input and recommends adding various access structures. Which three does it consider the impact of adding when it generates recommendations?
Options
- AMaterialized views
- BIndexes
- CPartitions
- DTablespaces
- EV$ performance views
- FHints
How the community answered
(28 responses)- A82% (23)
- D7% (2)
- E4% (1)
- F7% (2)
Community Discussion
No community discussion yet for this question.