Which two statements are true about Automatic Statistics collection by the Optimizer?

The correct answer is A. Statistics are collected during automatic maintenance tasks. E. Statistics are gathered after table statistics are marked stale. https://docs.oracle.com/cd/B28359_01/server.111/b28274/stats.htm

Automatic Performance Tuning Features

Question

Options

AStatistics are collected during automatic maintenance tasks.
BAny fixed objects are disregarded.
CAny external tables are incorporated.
DAll tables in the data dictionary are included by defaults.
EStatistics are gathered after table statistics are marked stale.

How the community answered

(32 responses)

A
84% (27)
B
3% (1)
C
9% (3)
D
3% (1)

Explanation

https://docs.oracle.com/cd/B28359_01/server.111/b28274/stats.htm

Topics

#optimizer statistics#automatic maintenance#stale statistics#automatic stats collection

Community Discussion

No community discussion yet for this question.

Full 1Z0-417 Practice