Oracle
1Z0-931-20 · Question #45
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?
The correct answer is E. The indexing feature is implemented as an automatic task that runs at a fixed interval. Explanation/Reference:
Developing with Autonomous Database
Question
Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?
Options
- AProcess includes identify candidates, create invisible auto indexes , verify with implement if
- BYou can use the dbms_auto_index package to report on the automatic task and to set your
- CIt is enabled by default.
- DYou can control behavior at the statement level using the use_aoto_indexes or
- EThe indexing feature is implemented as an automatic task that runs at a fixed interval.
How the community answered
(26 responses)- A4% (1)
- B8% (2)
- D4% (1)
- E85% (22)
Explanation
Explanation/Reference:
Topics
#automatic indexing#dbms_auto_index#invisible indexes#ADW performance
Community Discussion
No community discussion yet for this question.