Oracle
1Z0-050 · Question #12
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the…
The correct answer is C. The job is terminated and the statistics for the remaining objects are collected the next time that the. See the full explanation below for the reasoning.
Question
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects. Which statement is true in this scenario?
Options
- AThis produces an error and the statistics collected are locked until the next time that the maintenance
- BThe job is terminated and the statistics collected are restored to a time before the job started
- CThe job is terminated and the statistics for the remaining objects are collected the next time that the
- DThe statistics collection continues until all objects are processed
How the community answered
(30 responses)- A3% (1)
- B3% (1)
- C83% (25)
- D10% (3)
Community Discussion
No community discussion yet for this question.