网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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.
参考答案
参考解析
解析：
AWR 基础结构由两个主要部分组成：
• 一个内存中统计信息收集工具，Oracle Database 11g组件使用它来收集统计信息。出于性能方面的考虑，这些统计信息存储在内存中。可以通过动态性能(V$) 视图访问存储在内存中的统计信息。
• 代表该工具持久部分的AWR 快照。AWR 快照可以通过数据字典视图和EnterpriseManager Database Control 来访问。
它为内部Oracle 服务器组件提供服务来收集、处理、维护和使用性能统计信息，以便进行问题检测和自优化。 AWR 中包含数百个表，所有这些表均属于SYSMAN方案且存储在SYSAUX表空间中。
更多 “多选题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 dictionary views.DThe snapshots collected by the AWR are used by self-tuning components in the database.” 相关考题
考题
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.
考题
Which two statements are true about the Automatic Diagnostic Repository (ADR)?() (Choose two.)
A. The ADR base keeps all diagnostic information in binary formatB. SQL*Plus provides the ADRI script, which can be used to work with ADRC. The ADR can be used for problem diagnosis only when the database is openD. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE. The ADR can be used for problem diagnosis even when the database instance is downF. The ADR base is shared across multiple instances
考题
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 databaseD. 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.
考题
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
考题
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.
考题
Which two statements about NTP version 4 are true？（）A、It supports fast synchronization at starting and before network failuresB、It supports automatic server discoveryC、It uses a fixed-point arithmetionD、It supports the "nanokernel" kernel implementationE、It does not support Public-Key Cryptography
考题
Which two statements are true about L2TP tunnels?（） (Choose two.)A、Traffic is clear textB、Traffic is encryptedC、They are initiated by the LNSD、They are initiated by the LAC
考题
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.
考题
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.
考题
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.
考题
Which two statements about the Cisco Nexus 1000V VSM are true?（）A、It performs switching decisions and forwarding for the VEMB、It can be run on a virtual machineC、It can be used for remote VEM switching Iine cards
考题
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.
考题
Which two statements are true about the Automatic Diagnostic Repository （ADR）？（） A、 The ADR base keeps all diagnostic information in binary formatB、 SQL*Plus provides the ADRI script， which can be used to work with ADRC、 The ADR can be used for problem diagnosis only when the database is openD、 The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE、 The ADR can be used for problem diagnosis even when the database instance is downF、 The ADR base is shared across multiple instances
考题
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.
考题
Which two statements about bigfile tablespaces are true？ （）A、The bigfile tablespace have only one data file.B、The segment space management is automatic.C、The extent management is dictionary managed.D、The database can have only one bigfile tablespace.E、The bigfile tablespace can be converted to a smallfile tablespace.
考题
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.
考题
Which two statements about Automatic Storage Management （ASM） are true？（）A、ASM provides mirroring on file by file basis.B、ASM provides automatic load balancing across all ASM disks.C、ASM supports the Oracle database and operating system files.D、ASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.
考题
单选题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.
考题
多选题Which two statements are true about L2TP tunnels?（） (Choose two.)ATraffic is clear textBTraffic is encryptedCThey are initiated by the LNSDThey are initiated by the LAC
考题
多选题Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）AThe ADDM requires at least four AWR snapshots for analysis.BThe ADDM runs after each AWR snapshot is collected automatically by MMON.CThe results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.DThe ADDM analysis provides only diagnostic information but does not provide recommendations.EThe ADDM calls other advisors if required， but does not provide recommendations about the advisors.
考题
多选题Which two statements are true about AH?（） (Choose two.)AAH provides data integrity.BAH is identified by IP protocol 50.CAH is identified by IP protocol 51.DAH cannot work in conjunction with ESP
考题
单选题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 expirationduration.
考题
多选题Which two statements are true about the relationship between static NAT and proxy ARP? （）(Choose two.)AIt is necessary to forward ARP requests to remote hosts.BIt is necessary when translated traffic belongs to the same subnet as the ingress interface.CIt is not automatic and you must configure it.DIt is enabled by default and you do not need to configure it.
考题
多选题Which two statements about NTP version 4 are true？（）AIt supports fast synchronization at starting and before network failuresBIt supports automatic server discoveryCIt uses a fixed-point arithmetionDIt supports the nanokernel kernel implementationEIt does not support Public-Key Cryptography
考题
多选题Which two statements are true about the Automatic Diagnostic Repository (ADR)?（） (Choose two.)AThe ADR base keeps all diagnostic information in binary formatBSQL*Plus provides the ADRI script, which can be used to work with ADRCThe ADR can be used for problem diagnosis only when the database is openDThe ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullEThe ADR can be used for problem diagnosis even when the database instance is downFThe ADR base is shared across multiple instances
考题
多选题Which two statements about workload capture and replay operations are true?（）AThe clients must be created manually on the test machines to perform more realistic testing.BRestart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.CRestart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.DThe application state of the capture system must be identical to the application state of the replay system when the workload replay begins.
考题
多选题Which two statements about bigfile tablespaces are true？ （）AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe bigfile tablespace can be converted to a smallfile tablespace.
热门标签
最新试卷