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

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

相似考题

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

3. 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.

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

更多“多选题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 snapsh”相关问题

  • 第1题：

    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 the database 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 theautomatic purging of the snapshots.

    正确答案:B

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

    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

  • 第4题：

    Initially， for the Automatic Workload Repository （AWR） statistics， the retention period is set to 7 days， the collection interval is set to 30 minutes and the collection level is set to Typical in your production database.  You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However， when you observe the Memory Advisor on a Friday， you find that the statistics are available only for two days， Thursday and Friday， of that week.  What would have caused the statistics to be removed？（）

    • A、On Wednesday， the statistics have been purged.
    • B、On Wednesday， the retention period has been set to zero.
    • C、On Wednesday， the collection interval has been set to zero.
    • D、On Wednesday， the collection level has been changed to All.
    • E、On Wednesday， the retention period has been set to one day.
    • F、On Wednesday， the retention period has been set to two days.
    • G、On Wednesday， the collection level has been changed to Typical.
    • H、On Wednesday， the collection interval has been set to 1440 minutes.

    正确答案:F

  • 第5题：

    Initially， for the Automatic Workload Repository （AWR） statistics，the retention period is set to 7 days， the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However，when you observe the Memory Advisor on a Friday，you find that the statistics are available only for two days， Thursday and Friday，of that week. What would have caused the statistics to be removed？（）

    • A、On Wednesday， the statistics have been purged.
    • B、On Wednesday， the retention period has been set to zero.
    • C、On Wednesday， the collection interval has been set to zero.
    • D、On Wednesday， the collection level has been changed to All.
    • E、On Wednesday， the retention period has been set to one day.
    • F、On Wednesday， the retention period has been set to two days
    • G、On Wednesday, the collection level has been changed to Typical.
    • H、On Wednesday, the collection interval has been set to 1440 minutes.

    正确答案:F

  • 第6题：

    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

  • 第7题：

    The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?（）

    • A、set DB_FLASHBACK_RETENTION_TARGET=10800  
    • B、create a new scheduler window for the time period of 24 hours and use the optimizer statistics 
    • C、modify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings 
    • D、specify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations

    正确答案:D

  • 第8题：

    单选题
    You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）
    A

    Memory Advisors

    B

    Segment Advisors

    C

    SQL Tuning and Access Advisors

    D

    Automated Workload Repository （AWR）

    E

    Automatic Database Diagnostic Monitor （ADDM）


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

  • 第9题：

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


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

  • 第10题：

    单选题
    Initially， for the Automatic Workload Repository （AWR） statistics， the retention period is set to 7 days， the collection interval is set to 30 minutes and the collection level is set to Typical in your production database.  You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However， when you observe the Memory Advisor on a Friday， you find that the statistics are available only for two days， Thursday and Friday， of that week.  What would have caused the statistics to be removed？（）
    A

    On Wednesday， the statistics have been purged.

    B

    On Wednesday， the retention period has been set to zero.

    C

    On Wednesday， the collection interval has been set to zero.

    D

    On Wednesday， the collection level has been changed to All.

    E

    On Wednesday， the retention period has been set to one day.

    F

    On Wednesday， the retention period has been set to two days.

    G

    On Wednesday， the collection level has been changed to Typical.

    H

    On Wednesday， the collection interval has been set to 1440 minutes.


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

  • 第11题：

    多选题
    You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）
    A

    Average row size

    B

    Last analyzed date

    C

    Size of table in bytes

    D

    Size of table in database blocks

    E

    Number of free blocks in the free list

    F

    Number of extents present in the table.


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

  • 第12题：

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


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

  • 第13题：

    You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）

    • A、Memory Advisors
    • B、Segment Advisors
    • C、SQL Tuning and Access Advisors
    • D、Automated Workload Repository （AWR）
    • E、Automatic Database Diagnostic Monitor （ADDM）

    正确答案:C

  • 第14题：

    You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

    • A、Average row size
    • B、Last analyzed date
    • C、Size of table in bytes
    • D、Size of table in database blocks
    • E、Number of free blocks in the free list
    • F、Number of extents present in the table.

    正确答案:A,B,D

  • 第15题：

    You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

    • A、Set the UNDO_RETENTION parameter to AUTO.
    • B、Create an initial undo segment in undotablespace.
    • C、Set the UNDO_RETENTION parameter to 900 or more
    • D、Set the initialization parameter UNDO_MANAGEMENT to AUTO
    • E、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

    正确答案:D,E

  • 第16题：

    You work as a database administrator for Supportcenter.cn. 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

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

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


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

  • 第20题：

    多选题
    You work as a database administrator for Supportcenter.cn. 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


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

  • 第21题：

    单选题
    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 the database 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 theautomatic purging of the snapshots.


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

  • 第22题：

    多选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    Initially， for the Automatic Workload Repository （AWR） statistics，the retention period is set to 7 days， the collection interval is set to 30 minutes and the collection level is set to Typical in your production database. You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However，when you observe the Memory Advisor on a Friday，you find that the statistics are available only for two days， Thursday and Friday，of that week. What would have caused the statistics to be removed？（）
    A

    On Wednesday， the statistics have been purged.

    B

    On Wednesday， the retention period has been set to zero.

    C

    On Wednesday， the collection interval has been set to zero.

    D

    On Wednesday， the collection level has been changed to All.

    E

    On Wednesday， the retention period has been set to one day.

    F

    On Wednesday， the retention period has been set to two days

    G

    On Wednesday, the collection level has been changed to Typical.

    H

    On Wednesday, the collection interval has been set to 1440 minutes.


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

相关内容