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.
Answer:C
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.