The SALES table in your database undergoes frequent changes. While observing the statistics for
the table in the middle of the day, you find a change since the last observation. But the information
about the statistics collection is not recorded in the DBA_TAB_STATS_HISTORY. Identify the
reason for this.
A.
The AWR retention time was set to zero.
B.
The STATISTICS_LEVEL parameter was set to BASIC.
C.
Some of the statistics were collected using the ANALYZE command.
D.
There were user-defined statistics that were set by using the
DBMS_STATS.SET_TABLE_STATS procedure.
if the stats is collected by analyze, it won’t be recorded in tab_statistics_history
C is correct