Oracle
1Z0-117 · Question #54
1Z0-117 Question #54: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-117 to reveal the answer and full explanation for question #54. The question stem and answer options stay visible for context.
Question
In which three situations must you collect optimizer statistics manually for database objects in addition to automatic statistics collection?
Options
- AWhen substantial DML activity occurs between the nightly automatic stats gathering maintenance job
- BWhen substantial activity occurs on a partition of the partitioned table.
- CWhen a table is used for bulk loads that add 10% or more to the total size of the table
- DWhen an index is created or dropped for a column
- EWhen the degree of parallelism is explicitly defined for a table
Unlock 1Z0-117 to see the answer
You've previewed enough free 1Z0-117 questions. Unlock 1Z0-117 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.