1Z0-062 Question #191: Real Exam Question with Answer & Explanation

Question

Options

• APredefined maintenance tasks consist of automatic optimizer statistics collection, running
• BA repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.
• CThey run at predefined time intervals that are intended to occur during a period of low system
• DAn Oracle Scheduler job is created for each maintenance tasks that is scheduled to run in a
• EA maintenance window is automatically extended until all the maintenance tasks defined are

Explanation

Oracle automated maintenance tasks run via Oracle Scheduler during predefined maintenance windows to perform background operations like optimizer statistics collection with minimal system impact.

Common mistakes.

• B. Maintenance task execution history is stored in the SYSAUX tablespace, not the SYSTEM tablespace, because SYSAUX is the designated location for auxiliary repository and workload data.
• E. Maintenance windows have fixed end times and do not auto-extend; tasks that have not completed when the window closes are stopped and resume during the next available window.

Concept tested. Oracle automated maintenance tasks and scheduler windows

Reference. https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-automated-database-maintenance-tasks.html

No community discussion yet for this question.