Oracle
1Z0-417 · Question #67
When preparing a new database installation, you want to ensure automatic collection of timed statistics. Which three configuration parameters are applicable?
The correct answer is A. STATISTICS_LEVEL parameter set to TYPICAL B. STATISTICS_LEVEL parameter set to All C. TIMED_STATISTICS parameter set to true. See the full explanation below for the reasoning.
Question
When preparing a new database installation, you want to ensure automatic collection of timed statistics. Which three configuration parameters are applicable?
Options
- ASTATISTICS_LEVEL parameter set to TYPICAL
- BSTATISTICS_LEVEL parameter set to All
- CTIMED_STATISTICS parameter set to true
- DALL_TIMED_STATISTICS parameter set to TRUE
- EAUTO_STATS parameter set to TRUE
- FSTATISTICS_LEVEL parameter set to BASIC.
How the community answered
(40 responses)- A75% (30)
- D13% (5)
- E10% (4)
- F3% (1)
Community Discussion
No community discussion yet for this question.