单项选择题
You plan to set up the Automatic Workload Repository （AWR） baseline metric thresholds for a moving window baseline. Which action would you take before performing this task？（）
A. Compute the baseline statistics.
B. Take an immediate AWR snapshot.
C. Decrease the window size for the baseline.
D. Decrease the expiration time for the baseline.
相关考题
-
单项选择题
You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group ，you issued the following ASMCMD command： ASMCMD> lsdsk -I -d DATA Which statement is true regarding the outcome of this command？（）
A. The command succeeds but it retrieves only the disk names.
B. The command produces an error because the ASM instance is down.
C. The command succeeds but it shows only the status of the ASM instance.
D. The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value. -
多项选择题
Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATECHANNEL commands in RMAN（） (choose all that apply)
A. Limiting the input/output (I/O) bandwidth consumption
B. Specifying the size of backup sets and backup pieces
C. Specifying vendor-specific information for a media manager
D. Specifying the parallelism for backup and restore operations -
单项选择题
To generate recommendations to improve the performance of a set of SQL queries in an application， you execute the following blocks of code： BEGIN dbms_advisor.create_task（dbms_advisor.sqlaccess_advisor，’TASK1’）； END； / BEGIN dbms_advisor.set_task_parameter（’TASK1’，’ANALYSIS_SCOPE’，’ALL’）； dbms_advisor.set_task_parameter（’TASK1’，’MODE’，’COMPREHENSIVE’）； END； / BEGIN dbms_advisor.execute_task（’TASK1’）； dbms_output.put_line（dbms_advisor.get_task_script（’TASK1’））； END； / The blocks of code execute successfully；however，you do not get the required outcome. What could be the reason？（）
A. A template needs to be associated with the task.
B. A workload needs to be associated with the task.
C. The partial or complete workload scope needs to be associated with the task.
D. The type of structures （indexes， materialized views， or partitions） to be recommended need to be specified for the task.
