niusouti.com

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

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

相似考题

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

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

3.Which two statements are true about L2TP tunnels?（） (Choose two.)A、Traffic is clear textB、Traffic is encrypted C、They are initiated by the LNSD、They are initiated by the LAC

4.Which two statements are true about the RMAN validate database command?()A. It checks the database for intrablock corruptions.B. It can detect corrupt pfiles.C. It can detect corrupt spfiles.D. It checks the database for interblock corruptions.E. It can detect corrupt block change tracking files.

更多“Which two statements are true about the Automatic Database D”相关问题

  • 第1题：

    Which two statements are true about the RMAN validate database command?（）

    • A、It checks the database for intrablock corruptions.
    • B、It can detect corrupt pfiles.
    • C、It can detect corrupt spfiles.
    • D、It checks the database for interblock corruptions.
    • E、It can detect corrupt block change tracking files.

    正确答案:A,C

  • 第2题：

    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

  • 第3题：

    Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）

    • A、As ASM instance mounts an ASM control file
    • B、An ASM instance uses the ASMB process for rebalancing of disks within a disk group
    • C、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
    • D、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

    正确答案:C,D

  • 第4题：

    You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

    • A、 The database must have multiplexed redo log files
    • B、 The database must be in the MOUNT state to execute the command
    • C、 The database must be in the NOMOUNT state to execute the command
    • D、 The database must be opened in RESTRICTED mode before this operation
    • E、 The database must be opened with the RESETLOGS option after the flashback operation

    正确答案:B,E

  • 第5题：

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

    正确答案:A,B

  • 第6题：

    Which two statements are true about record groups?（）

    • A、They are stored in the database. 
    • B、They are stored in local Forms memory. 
    • C、The type is specified explicitly at design time. 
    • D、The type is implied by when and how it is created.

    正确答案:B,D

  • 第7题：

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


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

  • 第8题：

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


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

  • 第9题：

    多选题
    Which two statements are true about the RMAN validate database command?（）
    A

    It checks the database for intrablock corruptions.

    B

    It can detect corrupt pfiles.

    C

    It can detect corrupt spfiles.

    D

    It checks the database for interblock corruptions.

    E

    It can detect corrupt block change tracking files.


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

  • 第10题：

    多选题
    Which two statements are true about record groups?（）
    A

    They are stored in the database.

    B

    They are stored in local Forms memory.

    C

    The type is specified explicitly at design time.

    D

    The type is implied by when and how it is created.


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

  • 第11题：

    多选题
    Which two statements are true about the Automatic Diagnostic Repository (ADR)?（）
    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
    解析： 暂无解析

  • 第12题：

    多选题
    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表空间中。

  • 第13题：

    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

  • 第14题：

    Which two statements are true about the Automatic Diagnostic Repository （ADR）？（） 

    • 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

  • 第15题：

    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.

    正确答案:A,B

  • 第16题：

    You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)

    • A、Backup compression should be enabled
    • B、Parallelism for the channel should be set to 2
    • C、All the files must be backed up as backup sets
    • D、The backup may be stored either on disk or on media with media manager

    正确答案:C,D

  • 第17题：

    Which two statements are true about standard database auditing（）

    • A、DDL statements can be audited.
    • B、Statements that refer to stand-alone procedure can be audited.
    • C、Operations by the users logged on as SYSDBA cannot be audited.
    • D、Only one audit record is ever created for a session per audited statement even though it is executedmore than once.

    正确答案:A,B

  • 第18题：

    Which two statements are true about the roles in the Oracle database？（）

    • A、A role can be granted to itself.
    • B、Roles are owned by the SYS user.
    • C、Roles can be granted to other roles.
    • D、A role cannot be assigned external authentication.
    • E、A role can contain both system and object privileges.

    正确答案:C,E

  • 第19题：

    多选题
    You plan to execute the following command to perform a Flashback Database operation in your database: SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24); Which two statements are true about this?（）
    A

    The database must have multiplexed redo log files

    B

    The database must be in the MOUNT state to execute the command

    C

    The database must be in the NOMOUNT state to execute the command

    D

    The database must be opened in RESTRICTED mode before this operation

    E

    The database must be opened with the RESETLOGS option after the flashback operation


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

  • 第20题：

    多选题
    Which two statements are true about standard database auditing（）
    A

    DDL statements can be audited.

    B

    Statements that refer to stand-alone procedure can be audited.

    C

    Operations by the users logged on as SYSDBA cannot be audited.

    D

    Only one audit record is ever created for a session per audited statement even though it is executedmore than once.


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

  • 第21题：

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


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

  • 第22题：

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


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

  • 第23题：

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


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

相关内容