Oracle Cloud Infrastructure 2020 Architect Associate — Question 16

Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse? (Choose the best answer.)

Answer options

• A. Process includes identify candidates, create invisible auto indexes, verify with implement if performance improved and delete unused.
• B. You can control behavior at the statement level using the USE_AUTO_INDEXES or NO_USE_AUTO_INDEXES hints.
• C. You can use the DBMS_AUTO_INDEX package to report on the automatic task and to set your preferences.
• D. The indexing feature is implemented as an automatic task that runs at a fixed interval.
• E. It is enabled by default.

Correct answer: A

Explanation

Option A is incorrect because it misrepresents the process of Automatic Indexing; the actual process does not include a verification step with an implementation phase. Options B, C, D, and E are correct statements about how Automatic Indexing functions in Autonomous Data Warehouse.