Oracle Database 12c: Installation and Administration — Question 133

Which three statements are true about automated maintenance tasks? (Choose three.)

Answer options

• A. They run at predefined time intervals that are intended to occur during a period of low system load.
• B. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.
• C. A maintenance window is automatically extended until all the maintenance tasks defined are completed.
• D. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.
• E. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning

Correct answer: A, B, E

Explanation

Option A is correct because automated maintenance tasks are designed to run during low-load periods to minimize impact. Option B is accurate as each task indeed has an associated Oracle Scheduler job for scheduling. Option E is also true, listing common predefined tasks. Option C is incorrect because maintenance windows do not automatically extend; they have fixed durations. Option D is wrong as the history of task executions is not stored in the SYSTEM tablespace.