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

Which two statements are true about the Automatic Workload R

题目
多选题
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,B
解析： AWR 基础结构由两个主要部分组成：  • 一个内存中统计信息收集工具，Oracle Database 11g组件使用它来收集统计信息。出于性能方面的考虑，这些统计信息存储在内存中。可以通过动态性能(V$) 视图访问存储在内存中的统计信息。  • 代表该工具持久部分的AWR 快照。AWR 快照可以通过数据字典视图和EnterpriseManager Database Control 来访问。  它为内部Oracle 服务器组件提供服务来收集、处理、维护和使用性能统计信息，以便进行问题检测和自优化。 AWR 中包含数百个表，所有这些表均属于SYSMAN方案且存储在SYSAUX表空间中。
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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

第2题：

Which two statements are true about precedence values in policy?() (Choose two.)

A. 1 is the default precedence.

B. A lower number is preferred.

C. A higher number is preferred.

D. 100 is the default precedence.


参考答案：B, D

第3题：

Which two statements about workload capture and replay operations are true?()

A. The clients must be created manually on the test machines to perform more realistic testing.

B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.

C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.

D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.


参考答案：C, D

第4题：

Which three statements about performance analysis by SQL Performance Analyzer are true? （）

  • A、It detects changes in SQL execution plans.
  • B、It produces results that can be used to create the SQL plan baseline.
  • C、The importance of SQL statements is based on the size of the objects accessed.
  • D、It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
  • E、It shows only the overall impact on workload and not the net SQL impact on workload.

正确答案:A,B,D

第5题：

Which two statements are true about L2TP tunnels?（） (Choose two.)

  • A、Traffic is clear text
  • B、Traffic is encrypted 
  • C、They are initiated by the LNS
  • D、They are initiated by the LAC

正确答案:A,D

第6题：

Which two statements are true about AH?() (Choose two.)

A. AH provides data integrity.

B. AH is identified by IP protocol 50.

C. AH is identified by IP protocol 51.

D. AH cannot work in conjunction with ESP


参考答案：A, C

第7题：

Which two statements about NTP version 4 are true？（）

  • A、It supports fast synchronization at starting and before network failures
  • B、It supports automatic server discovery
  • C、It uses a fixed-point arithmetion
  • D、It supports the "nanokernel" kernel implementation
  • E、It does not support Public-Key Cryptography

正确答案:B,D

第8题：

Which two statements are true about the Automatic Diagnostic Repository (ADR)?() (Choose two.)

A. The ADR base keeps all diagnostic information in binary format

B. SQL*Plus provides the ADRI script, which can be used to work with ADR

C. The ADR can be used for problem diagnosis only when the database is open

D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

E. The ADR can be used for problem diagnosis even when the database instance is down

F. The ADR base is shared across multiple instances


参考答案：E, F

第9题：

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

第10题：

Which two statements are true about the relationship between static NAT and proxy ARP? （）(Choose two.)

  • A、It is necessary to forward ARP requests to remote hosts.
  • B、It is necessary when translated traffic belongs to the same subnet as the ingress interface.
  • C、It is not automatic and you must configure it.
  • D、It is enabled by default and you do not need to configure it.

正确答案:B,C

更多相关问题
相关内容