Oracle
1Z0-054 · Question #35
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…
The correct answer is C. Some of the statistics were collected using the ANALYZE command. See the full explanation below for the reasoning.
Question
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.
Options
- AThe AWR retention time was set to zero.
- BThe STATISTICS_LEVEL parameter was set to BASIC.
- CSome of the statistics were collected using the ANALYZE command.
- DThere were user-defined statistics that were set by using the
How the community answered
(46 responses)- A7% (3)
- B4% (2)
- C74% (34)
- D15% (7)
Community Discussion
No community discussion yet for this question.