Which procedure of the DBMS_RESOURCE_MANAGER package can you use to run the I/O Calibration tool to calibrate the I/O storage capabilities and estimate the maximum number of I/O requests and maximum latency time?
The CALIBRATE_IO procedure
To which value must the FILESYSTEMIO_OPTIONS initialization parameter be set to successfully run the CALIBRATE_IO procedure of the DBMS_RESOURCE_MANAGER package?
Either ASYNCH or SETALL
For a repeating baseline, what does MMON do with old baselines when it creates a baseline?
Automatically removes it
Which procedure of the DBMS_WORKLOAD_REPOSITORY package allows you to modify the window size for the system-defined moving window baseline?
The MODIFY_BASELINE_WINDOW_SIZE procedure
How must a lightweight job be created?
Using a template
Which input parameter of the CALIBRATE_IO procedure specifies the approximate number of physical disks in the database?
The num_physical_disks parameter
When using baseline templates, which process reviews the templates and creates the necessary baselines each night?
The MMON process
Which procedure of the DBMS_SCHEDULER package do you use to create a job template for generating lightweight jobs?
The CREATE_PROGRAM procedure
Which two views contain the status and results of running the CALIBRATE_IO procedure?
The V$IO_CALIBRATION_STATUS and DBA_RSRC_IO_CALIBRATE views
What is the primary benefit of using a persistent lightweight job over a regular job?
It creates less metadata, and reduces the time and redo required to start a job.
Which column of the DBA_AUTOTASK_CLIENT view displays the percentage of maintenance resources for high priority maintenance tasks?
The RESOURCE_PERCENTAGE column
Which action must you take to create the system-defined moving window baseline?
None, it is created by default.
What is the benefit of using baseline templates?
The system will automatically generate baselines for future time periods.
Which action must you take before you can set up AWR baseline metric thresholds for a specific baseline?
Compute the baseline statistics.
Significance Level thresholds are only supported by which type of metrics?
Which four server-generated alerts are enabled by default?
Snapshot Too Old, Tablespace Space Usage, Resumable Session Suspended, and Recovery Area Low on Free Space
In which situation would it be most useful to use a persistent lightweight job?
When you have users who are creating many jobs in a short period of time
If you do not specify the JOB_STYLE argument when creating a job using the CREATE_JOB procedure, is a regular or lightweight job created by default?
A regular job
Which background process spawns the Autotask Background Process (ABP) when a maintenance window starts?
The MMON process
All predefined maintenance windows use which resource plan by default?
The DEFAULT_MAINTENANCE_PLAN resource plan
By default, when you create an Oracle 11g database, which default resource plans are activated?
None, several default resource plans are created, but none is activated.
Which initialization parameter must be set to TRUE to successfully run the CALIBRATE_IO procedure of the DBMS_RESOURCE_MANAGER package computing latency?
The TIMED_STATISTICS parameter
Can you set privileges for persistent lightweight jobs?
No, they inherit them from their parent job template.
Which output parameter of the CALIBRATE_IO procedure identifies the maximum number of I/O requests that can be sustained per second?
The max_iops parameter
In which tablespace does the Autotask Background Process (ABP) store task execution history?
The SYSAUX tablespace
Which process determines and prioritizes jobs that need to be created for each maintenance task, creates the jobs, and assigns them to Scheduler job classes?
The Autotask Background Process (ABP)
By default, which three tasks are executed as part of the Automated Maintenance Task?
Optimizer statistics collection, Segment Advisor, and SQL Tuning Advisor
What is the maximum number of calibrations that can run concurrently?
Does performing I/O calibration positively or negatively affect running sessions?
Which column of the DBA_AUTOTASK_CLIENT view displays the average elapsed time, in seconds, for maintenance task jobs?
The MEAN_JOB_DURATION column
Which initialization parameter setting enables baselines by default?
STATISTICS_LEVEL=TYPICAL or STATISTICS_LEVEL=ALL
To what value is the size of the default system-defined moving window baseline set by default?
The size of the AWR retention time (eight days)
Which procedure of the DBMS_ WORKLOAD_REPOSITORY package can you use to create a repeating baseline template?
The CREATE_BASELINE_TEMPLATE procedure
When resizing the system-defined moving window, what is the maximum value that can be specified?
A value equal to the size of the AWR retention period
On which two bases can single AWR baselines be specified?
By either a specific snapshot range or a specific time period
When creating a resource plan directive, which argument defines the amount of I/O (in MB) that a session can use?
The SWITCH_IO_MEGABYTES argument
What information can be displayed using the DBA_AUTOTASK_CLIENT view?
Statistical data for each automated maintenance task
Which two input parameters can you specify when calling the CALIBRATE_IO procedure?
The NUM_PHYSICAL_DISKS and MAX_LATENCY parameters
When creating an AWR baseline, to what value should you set the expiration to ensure the baseline expires?
A value other than NULL
By default, what percentage of resources is allocated to automated maintenance operations with the DEFAULT_MAINTENANCE_PLAN resource plan?
To what does the term baseline refer?
A set of AWR snapshots taken over time
Which two actions do you take to resize the system-defined moving window?
Increase the AWR retention period, and increase the number of days in the moving window.
What do Significance Level thresholds use to determine when the threshold has been breached?
Which output parameter of the CALIBRATE_IO procedure identifies the average latency, based on the maximum number of sustainable I/O requests?
The actual_latency parameter
By default, which baseline is used to compute statistics with adaptive thresholds?
The system-defined moving window baseline
Which privilege must you have to successfully run the CALIBRATE_IO procedure of the DBMS_RESOURCE_MANAGER package?
The SYSDBA privilege
For what purpose is Resource Manager enabled during a maintenance window?
So that a resource plan can be automatically enabled when the maintenance window opens, preventing maintenance tasks from consuming excessive resources
Which argument of CREATE_JOB should you specify to create a lightweight job?