单选题Which statement is true when Automatic Workload Repository （AWR） baselines are created using baseline templates？（）AAWR baselines are always created as repeating baselines.BAWR baselines can be created on the basis of two time values.CAWR baselines are 

第1题：

You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）

• A、The collection level for the AWR should be set to BASIC
• B、The moving window size must be less than Undo Retention
• C、The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
• D、The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

第2题：

You plan to collect the Automatic Workload Repository （AWR） data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline.  What is the correct action to achieve this？（）  

• A、 Create and populate a SQL Tuning Set from the AWR on every Monday.
• B、 Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
• C、 Create a repeating baseline template.
• D、 Insert a finding directive for future ADDM tasks.

第3题：

You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）

• A、Run Segment Advisor
• B、Run the SQL Tuning Advisor (STA)
• C、Run the Automatic Workload Repository (AWR) report
• D、Run the SQL Access Advisor with a hypothetical workload

第4题：

Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?（）

• A、AWR baselines are always created as repeating baselines.
• B、AWR baselines can be created on the basis of two time values.
• C、AWR baselines are always created with infinite expiration duration.
• D、AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.

第5题：

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）

• A、 Cursor cache
• B、 Stored outline
• C、 SQL Tuning Set
• D、 Automatic Workload Repository （AWR） snapshots

第6题：

Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g？（）

• A、 It does not allow you to change the moving window size.
• B、 Adaptive threshold functionalities use it by default to compute statistics.
• C、 It is created by default with the window size being equal to the AWR retention time.
• D、 It is created when the first snapshot is collected by the Automatic Workload Repository （AWR）.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第14题：

Which two statements are true about the Automatic Workload Repository （AWR）（）

• A、All AWR tables belong to the SYSTEM schema.
• B、The AWR contains systemwide tracing and logging information.
• C、The snapshots collected by the AWR are accessible through data dictionary views.
• D、The snapshots collected by the AWR are used by self-tuning components in the database.

第15题：

You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）

• A、use enterprise manager
• B、use DBMS_SQL package
• C、use DBMS_AWR package
• D、use PRVT_WORKLOAD package
• E、query the AWR snapshot repository objects
• F、use DBMS_WORKLOAD_REPOSITORY package

第16题：

Which statement is true when Automatic Workload Repository （AWR） baselines are created using baseline templates？（）  

• A、 AWR baselines are always created as repeating baselines.
• B、 AWR baselines can be created on the basis of two time values.
• C、 AWR baselines are always created with infinite expiration duration.
• D、 AWR baselines are always created using the Automatic Workload Repository （AWR） retention period as expiration duration.

第17题：

Which three statements are true about Automatic Workload Repository (AWR)?（）

• A、All AWR tables belong to the SYSTEM schema.
• B、The AWR data is stored in memory and in the database.
• C、The snapshots collected by AWR are used by the self-tuning components in the database
• D、AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
• E、AWR contains system wide tracing and logging information.

第18题：

The following command is executed to create the baseline template：   SQL> EXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE（START_TIME=> TO_TIESTAMP（SYSDATE+2），  END_TIME=>TO_TIMESTAMP（SYSDATE+10）， BASELINE_NAME=>’Mybase4’，  TEMPLATE_NAME=>’Mytemp4’， EXPIRATION=>NULL）；   Which statement is true about the effect of the above command？（）  

• A、 It creates a baseline template that never expires.
• B、 It produces an error because no snapshot information is provided to create the baseline.
• C、 It creates a baseline template that expires after the Automatic Workload Repository （AWR） retention period.
• D、 It creates a repeating baseline template that repeats after the Automatic Workload Repository （AWR） retention period.

第19题：

第20题：

第21题：

第22题：

第23题：