多选题You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set

题目
多选题
You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. Which two statements are true in this scenario for the features enabled for ASM? （）
A

The ASM-preferred mirror read feature is enabled.

B

The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.

C

The ASM disk is dropped immediately from a disk group when it becomes unavailable.

D

The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.

相似考题

1.You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:ALTER DISKGROUP dg01 SET ATTRIBUTE ‘disk_repair_time‘ = ‘5h‘;To which disks in the disk group will the new value be applicable?（）A. all disks in the disk groupB. all disks that are currently in OFFLINE modeC. all disks that are not currently in OFFLINE modeD. all disks in the disk group only if all of them are ONLINE

2.You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）A、 mount the new disk group in the ASM instanceB、 restart the ASM instance and the production database instanceC、 register the new disk groups in the production database instanceD、 restart the ASM instance without restarting the production database instanceE、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

3. You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'; To which disks in the disk group will the new value be applicable?（）A、all disks in the disk groupB、all disks that are currently in OFFLINE modeC、all disks that are not currently in OFFLINE modeD、all disks in the disk group only if all of them are ONLINE

4.You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.All databases of all versions use Automatic Storage Management (ASM).Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）A. The ASM compatibility attribute controls the format of the disk group metadata.B. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.C. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.D. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.E. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

参考答案和解析
正确答案： D,B
解析： 暂无解析
更多“多选题You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set ”相关问题

  • 第1题：

    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

  • 第2题：

    You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. Which two statements are true in this scenario for the features enabled for ASM? （）

    • A、The ASM-preferred mirror read feature is enabled.
    • B、The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.
    • C、The ASM disk is dropped immediately from a disk group when it becomes unavailable.
    • D、The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.

    正确答案:A,B

  • 第3题：

    You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours：   ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H；   Which statement is true in this scenario？（）

    • A、 It starts the ASM fast mirror resync.
    • B、 All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
    • C、 It drops all disk paths from the dga disk group.
    • D、 All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.

    正确答案:D

  • 第4题：

    You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）

    • A、The ASM compatibility attribute controls the format of the disk group metadata.
    • B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
    • C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
    • D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
    • E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

    正确答案:A,B,D

  • 第5题：

    You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure.  Which statements will be true in this scenario？（）

    • A、 The disk is immediately dropped from the disk group.
    • B、 The ASM tracks the extents that are modified during the outa
    • C、 The ASM migrates the extents from the unavailable disk to the remaining disks.
    • D、 The disk automatically goes offline.

    正确答案:B,D

  • 第6题：

    The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation?（）

    • A、The databases configured to use the ASM instance are mounted
    • B、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
    • C、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
    • D、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

    正确答案:B,C

  • 第7题：

    多选题
    You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.  What configuration would you effect to achieve your objective？（）
    A

    Set the ASM compatibility attribute for the ASM disk group to 11.1.0.

    B

    Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.

    C

    Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.

    D

    Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.


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

  • 第8题：

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


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

  • 第9题：

    多选题
    You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）
    A

    The ASM compatibility attribute controls the format of the disk group metadata.

    B

    RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

    C

    The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

    D

    The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

    E

    The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.


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

  • 第10题：

    单选题
    You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file：   INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M   ASM_DISKGROUPS = DG1， DG2  DB_UNIQUE_NAME = +ASM   You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）
    A

     only the INSTANCE_TYPE initialization parameter is set to an invalid value

    B

     only the ASM_POWER_LIMIT initialization parameter is set to an invalid value

    C

     only the LARGE_POOL_SIZE initialization parameter is set to an invalid value

    D

     both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values


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

  • 第11题：

    单选题
    Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
    A

    mount the new disk group in the ASM instance

    B

    restart the ASM instance and the production database instance

    C

    register the new disk groups in the production database instance

    D

    restart the ASM instance without restarting the production database instance

    E

    include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance


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

  • 第12题：

    多选题
    You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario？（）
    A

    The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.

    B

    RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.

    C

    The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.

    D

    ASM compatibility controls which features for the ASM will be enabled.


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

  • 第13题：

    You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.  What configuration would you effect to achieve your objective？（）  

    • A、 Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
    • B、 Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
    • C、 Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
    • D、 Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

    正确答案:A,D

  • 第14题：

    Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

    • A、mount the new disk group in the ASM instance
    • B、restart the ASM instance and the production database instance
    • C、register the new disk groups in the production database instance
    • D、restart the ASM instance without restarting the production database instance
    • E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

    正确答案:A

  • 第15题：

    The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation? （）(Choose two.)

    • A、The databases configured to use the ASM instance are mounted
    • B、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
    • C、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
    • D、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

    正确答案:B,C

  • 第16题：

    You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）

    • A、 INSTANCE_TYPE
    • B、 DB_UNIQUE_NAME
    • C、 ASM_DISKSTRING
    • D、 ASM_POWER_LIMIT

    正确答案:A

  • 第17题：

    You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file：   INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M   ASM_DISKGROUPS = DG1， DG2  DB_UNIQUE_NAME = +ASM   You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）

    • A、 only the INSTANCE_TYPE initialization parameter is set to an invalid value
    • B、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid value
    • C、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid value
    • D、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values

    正确答案:D

  • 第18题：

    You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.  Which statements are true regarding extent management and allocation units in the ASM disk group？（）

    • A、 The au_size disk group attribute determines the size of allocation units in the disk group. 
    • B、 The allocation unit size may vary but the extent size is fixed.
    • C、 The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.
    • D、 Extent management is completely automated.

    正确答案:A,D

  • 第19题：

    多选题
    You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.  Which statements are true regarding extent management and allocation units in the ASM disk group？（）
    A

    The au_size disk group attribute determines the size of allocation units in the disk group.

    B

    The allocation unit size may vary but the extent size is fixed.

    C

    The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.

    D

    Extent management is completely automated.


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

  • 第20题：

    单选题
    You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group ，you issued the following ASMCMD command：   ASMCMD> lsdsk -I -d DATA   Which statement is true regarding the outcome of this command？（）
    A

     The command succeeds but it retrieves only the disk names.

    B

     The command produces an error because the ASM instance is down.

    C

     The command succeeds but it shows only the status of the ASM instance.

    D

     The command succeeds and retrieves information by scanning the disk headers based on an  ASM_DISKSTRING  value.


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

  • 第21题：

    单选题
    You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours：   ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H；   Which statement is true in this scenario？（）
    A

     It starts the ASM fast mirror resync.

    B

     All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.

    C

     It drops all disk paths from the dga disk group.

    D

     All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.


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

  • 第22题：

    单选题
    You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）
    A

     INSTANCE_TYPE

    B

     DB_UNIQUE_NAME

    C

     ASM_DISKSTRING

    D

     ASM_POWER_LIMIT


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

  • 第23题：

    多选题
    You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure.  Which statements will be true in this scenario？（）
    A

    The disk is immediately dropped from the disk group.

    B

    The ASM tracks the extents that are modified during the outa

    C

    The ASM migrates the extents from the unavailable disk to the remaining disks.

    D

    The disk automatically goes offline.


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

相关内容