单选题What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation？（）AThe ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.BThe ASM rebalance operation will consu

题目
单选题
What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation？（）
A

 The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.

B

 The ASM rebalance operation will consume fewer resources and complete in a longer amount of time.

C

 The ASM rebalance operation will be parallelized and should complete in a shorter amount of time.

D

 There is no ASM_POWER_LIMIT setting used in ASM.

E

 None of the above.

相似考题

1.Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record thestatus of the operation?()A. ADD DIRECTORYB. DROP DISKC. RESIZE DISKD. REBALANCEE. ADD FAILGROUP

2.Afterexecutingthecommandalterdiskgroupdiskgroup2dropdiskdg2a；youissuethefollowingcommandfromtheASMinstance：Selectgroup_number，count（*）fromv$asm_operation；WhatistheimplicationifthequeryagainstV$ASM_OPERATIONreturnszerorows？（）A.Thedropdiskoperationisstillproceedingandyoucannotyetruntheundropdisksoperation.B.Thedropdiskoperationiscompleteandyoucanruntheundropdiskscommandifneeded.C.Thedropdiskoperationiscompleteandyoucannotruntheundropdiskcommand.D.ThequerywillfailsincethereisnotaV$ASM_OPERATIONviewavailableinanASMinstance.E.Noneoftheaboveistrue.

3.You administer an online transaction processing (OLTP) system whose database is stored in AutomaticStorage Management (ASM) and whose disk group use normal redundancy.One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.Which two recommendations should you make to speed up the rebalance operation if this type of failurehappens again?（）A. Increase the value of the ASM_POWER_LIMIT parameter.B. Set the DISK_REPAIR_TIME disk attribute to a lower value.C. Specify the statement that adds the disk back to the disk group.D. Increase the number of ASMB processes.E. Increase the number of DBWR_IO_SLAVES in the ASM instance.

4.What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?()A. The number of DBWR processes increasesB. The number of ASMB processes increasesC. The number of DBWR_TO_SLAVES increasesD. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation？（）A  The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.B  The ASM rebalance operation will c”相关问题

  • 第1题：

    Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record thestatus of the operation?（）

    • A、ADD DIRECTORY
    • B、DROP DISK
    • C、RESIZE DISK
    • D、REBALANCE
    • E、ADD FAILGROUP

    正确答案:A

  • 第2题：

    You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command：  ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）

    • A、The rebalancing of the disk group would be stopped.
    • B、The rebalancing of the disk group would be completed as fast as possible.
    • C、The command would result in an error because the value of POWER cannot be 0.
    • D、The rebalancing of the disk group would be completed without affecting the disk group DG3.
    • E、The command would result in an error because the disk groups cannot be manually rebalanced.

    正确答案:A

  • 第3题：

    Which statement is true about the Manageability Monitor （MMON） background proces（）

    • A、It transfers statistics from memory to disk at regular intervals.
    • B、It coordinates the rebalance activity for disk groups when ASM is used.
    • C、It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.
    • D、It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.

    正确答案:A

  • 第4题：

    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

  • 第5题：

    What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?（）

    • A、The number of DBWR processes increases
    • B、The number of ASMB processes increases
    • C、The number of DBWR_TO_SLAVES increases
    • D、The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead

    正确答案: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题：

    单选题
    What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation？（）
    A

     The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.

    B

     The ASM rebalance operation will consume fewer resources and complete in a longer amount of time.

    C

     The ASM rebalance operation will be parallelized and should complete in a shorter amount of time.

    D

     There is no ASM_POWER_LIMIT setting used in ASM.

    E

     None of the above.


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

  • 第8题：

    单选题
    Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation？（）
    A

     ADD DIRECTORY

    B

     DROP DISK

    C

     RESIZE DISK

    D

     REBALANCE

    E

     ADD FAILGROUP


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

  • 第9题：

    单选题
    You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command：  ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）
    A

    The rebalancing of the disk group would be stopped.

    B

    The rebalancing of the disk group would be completed as fast as possible.

    C

    The command would result in an error because the value of POWER cannot be 0.

    D

    The rebalancing of the disk group would be completed without affecting the disk group DG3.

    E

    The command would result in an error because the disk groups cannot be manually rebalanced.


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

  • 第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题：

    单选题
    Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record thestatus of the operation?（）
    A

    ADD DIRECTORY

    B

    DROP DISK

    C

    RESIZE DISK

    D

    REBALANCE

    E

    ADD FAILGROUP


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

  • 第12题：

    单选题
    Which statement is true about the Manageability Monitor （MMON） background proces（）
    A

    It transfers statistics from memory to disk at regular intervals.

    B

    It coordinates the rebalance activity for disk groups when ASM is used.

    C

    It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.

    D

    It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.


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

  • 第13题：

    What is the net effect of the following command？（）   alter diskgroup dgroup1 drop disk abc；

    • A、 The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.
    • B、 The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.
    • C、 The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.
    • D、 This command will fail because you cannot drop a specific disk in an ASM disk group.
    • E、 The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.

    正确答案:C

  • 第14题：

    After executing the command alter diskgroup disk group2 drop disk dg2a； you issue the following command from the ASM instance：   Select group_number， count（*） from v$asm_operation；   What is the implication if the query against V$ASM_OPERATION returns zero rows？（）  

    • A、 The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.
    • B、 The drop disk operation is complete and you can run the undrop disks command if needed.
    • C、 The drop disk operation is complete and you cannot run the undrop disk command.
    • D、 The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance. 
    • E、 None of the above is true.

    正确答案:C

  • 第15题：

    Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance then gradually returns to normal levels. Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks？（）

    • A、 increase the number of checkpoint processes
    • B、 define the POWER option while adding or removing the disks
    • C、 increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES
    • D、 increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES
    • E、 increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal

    正确答案:B,E

  • 第16题：

    What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation？（）  

    • A、 The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.
    • B、 The ASM rebalance operation will consume fewer resources and complete in a longer amount of time.
    • C、 The ASM rebalance operation will be parallelized and should complete in a shorter amount of time.
    • D、 There is no ASM_POWER_LIMIT setting used in ASM.
    • E、 None of the above.

    正确答案:C

  • 第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题：

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


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

  • 第19题：

    多选题
    You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?（）
    A

    Increase the value of the ASM_POWER_LIMIT parameter.

    B

    Set the DISK_REPAIR_TIME disk attribute to a lower value.

    C

    Specify the statement that adds the disk back to the disk group.

    D

    Increase the number of ASMB processes.

    E

    Increase the number of DBWR_IO_SLAVES in the ASM instance.


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

  • 第20题：

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


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

  • 第21题：

    单选题
    What is the net effect of the following command？（）   alter diskgroup dgroup1 drop disk abc；
    A

     The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.

    B

     The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.

    C

     The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.

    D

     This command will fail because you cannot drop a specific disk in an ASM disk group.

    E

     The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.


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

  • 第22题：

    单选题
    After executing the command alter diskgroup disk group2 drop disk dg2a； you issue the following command from the ASM instance：   Select group_number， count（*） from v$asm_operation；   What is the implication if the query against V$ASM_OPERATION returns zero rows？（）
    A

     The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.

    B

     The drop disk operation is complete and you can run the undrop disks command if needed.

    C

     The drop disk operation is complete and you cannot run the undrop disk command.

    D

     The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance. 

    E

     None of the above is true.


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

  • 第23题：

    单选题
    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
    解析： 暂无解析

  • 第24题：

    单选题
    What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?（）
    A

    The number of DBWR processes increases

    B

    The number of ASMB processes increases

    C

    The number of DBWR_TO_SLAVES increases

    D

    The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead


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

相关内容