1Z0-062 · Question #191
Which three statements are true about automated maintenance tasks?
The correct answer is A. Predefined maintenance tasks consist of automatic optimizer statistics collection, running C. They run at predefined time intervals that are intended to occur during a period of low system D. An Oracle Scheduler job is created for each maintenance tasks that is scheduled to run in a. Oracle automated maintenance tasks run via Oracle Scheduler during predefined maintenance windows to perform background operations like optimizer statistics collection with minimal system impact.
Question
Which three statements are true about automated maintenance tasks?
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
How the community answered
(63 responses)- A95% (60)
- B3% (2)
- E2% (1)
Why each option
Oracle automated maintenance tasks run via Oracle Scheduler during predefined maintenance windows to perform background operations like optimizer statistics collection with minimal system impact.
Predefined maintenance tasks include automatic optimizer statistics collection and other background jobs that are part of the default Oracle maintenance framework, making this statement accurate.
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.
Maintenance windows are scheduled during periods of low system activity such as nights and weekends, specifically to reduce the performance impact on production workloads.
Oracle Scheduler creates a dedicated job for each maintenance task, enabling those tasks to be managed, monitored, and executed within the defined maintenance windows.
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
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-automated-database-maintenance-tasks.html
Topics
Community Discussion
No community discussion yet for this question.