Exam 1z0-931-20 topic 1 question 55 discussion

Actual exam question from Oracle's 1z0-931-20

Question #: 55
Topic #: 1

[All 1z0-931-20 Questions]

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

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.

Show Suggested Answer

Suggested Answer: A 🗳️

by TomSpring at May 9, 2021, 7:50 a.m.

Comments

Submit Cancel

TomSpring

Highly Voted 4 years, 2 months ago

As per https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-index.html#GUID-D51A4F85-3AE5-4B7D-9B27-32CEDE8DBD79 - Auto Indexing is disabled by default in Autonomous Database. So, correct answer should be E.

upvoted 16 times

...

EkeGabriel

Most Recent 3 years, 5 months ago

question is "not true", Ans is E: cos indexing is disabled by default

upvoted 1 times

...

Rodrigoef

3 years, 5 months ago

Selected Answer: E

Is NOT enabled by default. The question is asking for the WRONG answer

upvoted 1 times

...

antonica

3 years, 9 months ago

D , Autoindex is disable by default, https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-index.html#GUID-D51A4F85-3AE5-4B7D-9B27-32CEDE8DBD79

upvoted 1 times

...

AJ22

3 years, 10 months ago

E is the right answer. Remember the question asks what is NOT true? A is ture. E is not. Auto index is not enabled by defualt.

upvoted 1 times

...