niusouti.com

多选题Which two statements are true about the Automatic Workload Repository （AWR）（）AAll AWR tables belong to the SYSTEM schema.BThe AWR contains systemwide tracing and logging information.CThe snapshots collected by the AWR are accessible through data dictio

题目
多选题
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.

相似考题

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 BASICB. The moving window size must be less than Undo RetentionC. The moving window size should be greater than the Automatic Workload Repository (AWR) retention periodD. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

2.Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.()A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Repository (AWR) snapshots

3.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 BASICB、The moving window size must be less than Undo RetentionC、The moving window size should be greater than the Automatic Workload Repository (AWR) retention periodD、The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

4.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).

更多“多选题Which two statements are true about the Automatic Workload Repository （AWR）（）AAll AWR tables belong to the SYSTEM schema.BThe AWR contains systemwide tracing and logging information.CThe snapshots collected by the AWR are accessible through data dictio”相关问题

  • 第1题：

    Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）

    • A、The ADDM requires at least four AWR snapshots for analysis.
    • B、The ADDM runs after each AWR snapshot is collected automatically by MMON.
    • C、The results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.
    • D、The ADDM analysis provides only diagnostic information but does not provide recommendations.
    • E、The ADDM calls other advisors if required， but does not provide recommendations about the advisors.

    正确答案:B,C

  • 第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.

    正确答案:C

  • 第3题：

    In your database，the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）

    • A、The optimizer statistics are collected automatically.
    • B、Only the timed operating system （OS） statistics and plan execution statistics are collected.
    • C、The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
    • D、The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. 
    • E、Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

    正确答案:D

  • 第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.

    正确答案:B

  • 第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

    正确答案:A,C

  • 第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）.

    正确答案:B,C

  • 第7题：

    Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future.  What action would you take to achieve this task（）

    • A、Insert finding directives for ADDM tasks in the future.
    • B、Create a baseline on a pair of snapshots spanning the peak-load period.
    • C、Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.
    • D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots

    正确答案:B

  • 第8题：

    in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impactof this setting（）

    • A、Optimizer statistics are collected automatically.
    • B、Only timed operating system （OS） statistics and plan execution statistics are collected.
    • C、The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.
    • D、Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
    • E、The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

    正确答案:C

  • 第9题：

    多选题
    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).


    正确答案： A,B
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第12题：

    多选题
    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.


    正确答案： C,B
    解析： 暂无解析

  • 第13题：

    Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future.  What action would you take to achieve this task（）

    • A、Insert finding directives for ADDM tasks in the future.
    • B、Create a baseline on a pair of snapshots spanning the peak-load period.
    • C、Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.
    • D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automatic purging of snapshots.

    正确答案:B

  • 第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.

    正确答案:C,D

  • 第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

    正确答案:A,F

  • 第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.

    正确答案:B

  • 第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.

    正确答案:B,C,E

  • 第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.

    正确答案:A

  • 第19题：

    Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task？（）

    • A、Set the STATISTICS_LEVEL initialization parameter to ALL.
    • B、Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.
    • C、Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.
    • D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.

    正确答案:B

  • 第20题：

    多选题
    Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）
    A

    The ADDM requires at least four AWR snapshots for analysis.

    B

    The ADDM runs after each AWR snapshot is collected automatically by MMON.

    C

    The results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.

    D

    The ADDM analysis provides only diagnostic information but does not provide recommendations.

    E

    The ADDM calls other advisors if required， but does not provide recommendations about the advisors.


    正确答案： A,C
    解析： 暂无解析

  • 第21题：

    单选题
    In your database，the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）
    A

    The optimizer statistics are collected automatically.

    B

    Only the timed operating system （OS） statistics and plan execution statistics are collected.

    C

    The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

    D

    The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. 

    E

    Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.


    正确答案： C
    解析： 暂无解析

  • 第22题：

    多选题
    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.


    正确答案： B,D
    解析： AWR 基础结构由两个主要部分组成：  • 一个内存中统计信息收集工具，Oracle Database 11g组件使用它来收集统计信息。出于性能方面的考虑，这些统计信息存储在内存中。可以通过动态性能(V$) 视图访问存储在内存中的统计信息。  • 代表该工具持久部分的AWR 快照。AWR 快照可以通过数据字典视图和EnterpriseManager Database Control 来访问。  它为内部Oracle 服务器组件提供服务来收集、处理、维护和使用性能统计信息，以便进行问题检测和自优化。 AWR 中包含数百个表，所有这些表均属于SYSMAN方案且存储在SYSAUX表空间中。

  • 第23题：

    多选题
    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


    正确答案： D,B
    解析： 暂无解析

  • 第24题：

    多选题
    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


    正确答案： A,F
    解析： 暂无解析

相关内容