Oracle
1Z0-052 · Question #4
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 stat
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #4. The question stem and answer options stay visible for context.
Performing Database Maintenance
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
- AThe statistics collection continues until all objects are processed.
- BThe job is terminated and the statistics collected are restored to a time before the job started.
- CThis produces an error and the statistics collected are locked until the next time that the maintenance
- DThe job is terminated and the statistics for the remaining objects are collected the next time that the
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#automatic maintenance tasks#optimizer statistics#maintenance window#DBMS_STATS