Which statement is true in this scenario?

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?

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?

A.
The statistics collection continues until all objects are processed.

B.
The job is terminated and the statistics collected are restored to a time before the job
started.

C.
This produces an error and the statistics collected are locked until the next time that the
maintenance window is opened.

D.
The job is terminated and the statistics for the remaining objects are collected the next
time that the maintenance window is opened.

Explanation:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


chu

chu

The answer is:
D.
The job is terminated and the statistics for the remaining objects are collected the next
time that the maintenance window is opened.