Which three statements are true regarding the functioning of the Autotask Background Process
(ABP)? (Choose three.)
A.
It creates jobs without considering the priorities associated with them.
B.
It translates tasks into jobs for execution by the scheduler.
C.
It determines the list of jobs that must be created for each maintenance window.
D.
It is spawned by the MMON background process at the start of the maintenance window.
E.
It maintains a repository in the SYSTEM tablespace to store the history of the execution of all
tasks.
The Automated Maintenance Tasks are managed by the AutoTask Background Process (ABP).Following are the process functionalities:
• It converts automatic tasks into Scheduler jobs. It does not execute the maintenance tasks.
• It determines the jobs that need to be created for each maintenance task window.
• It stores task execution history in the SYSAUX tablespace
To view the task, run the below SQL
SQL> select client_name from DBA_AUTOTASK_CLIENT;
CLIENT_NAME
—————————————————————-
auto optimizer stats collection
auto space advisor
sql tuning advisor