nerdexam
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)
  • A
    4% (1)
  • B
    8% (2)
  • D
    4% (1)
  • E
    85% (22)

Explanation

Explanation/Reference:

Topics

#automatic indexing#dbms_auto_index#invisible indexes#ADW performance

Community Discussion

No community discussion yet for this question.

Full 1Z0-931-20 Practice