Oracle Database 12c: Installation and Administration — Question 241

What happens if a maintenance window closes before a job that collects optimizer statistics completes?

Answer options

• A. The job is terminated and the gathered statistics are not saved.
• B. The job is terminated but the gathered statistics are not published.
• C. The job continues to run until all statistics are gathered.
• D. The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.

Correct answer: D

Explanation

The correct answer is D because when a maintenance window closes, the job is terminated, but it ensures that any statistics collected for the remaining objects will be gathered during the next maintenance window. Options A and B incorrectly suggest that the statistics are completely lost or not published, which is not the case. Option C is incorrect as the job does not continue past the closure of the maintenance window.