违法和不良信息举报 联系客服
免费注册 登录

Initially， for the Automatic Workload Repository （AWR） stati

题目
单选题
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
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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.


参考答案：A

第2题：

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

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


参考答案：D

第4题：

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

第5题：

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

第6题：

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

第7题：

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

正确答案:D

第8题：

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

第9题：

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

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

正确答案:B

更多相关问题
相关内容