单选题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.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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
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
Afterexecutingthecommandalterdiskgroupdiskgroup2dropdiskdg2a；youissuethefollowingcommandfromtheASMinstance：Selectgroup_number，count（*）fromv$asm_operation；WhatistheimplicationifthequeryagainstV$ASM_OPERATIONreturnszerorows？（）A.Thedropdiskoperationisstillproceedingandyoucannotyetruntheundropdisksoperation.B.Thedropdiskoperationiscompleteandyoucanruntheundropdiskscommandifneeded.C.Thedropdiskoperationiscompleteandyoucannotruntheundropdiskcommand.D.ThequerywillfailsincethereisnotaV$ASM_OPERATIONviewavailableinanASMinstance.E.Noneoftheaboveistrue.
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.
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
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.
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.
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.
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.
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 processesB、 define the POWER option while adding or removing the disksC、 increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSESD、 increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVESE、 increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal
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 mountedB、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameterC、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedD、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
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.
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
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 valueB、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values
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 mountedB、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameterC、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedD、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
多选题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.)AThe databases configured to use the ASM instance are mountedBThe disk groups are mounted as per the ASM_DISKGROUPS initialization parameterCASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedDASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
单选题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.
多选题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?（）AIncrease the value of the ASM_POWER_LIMIT parameter.BSet the DISK_REPAIR_TIME disk attribute to a lower value.CSpecify the statement that adds the disk back to the disk group.DIncrease the number of ASMB processes.EIncrease the number of DBWR_IO_SLAVES in the ASM instance.
单选题Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation？（）A ADD DIRECTORYB DROP DISKC RESIZE DISKD REBALANCEE ADD FAILGROUP
多选题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？（）AThe databases configured to use the ASM instance are mountedBThe disk groups are mounted as per the ASM_DISKGROUPS initialization parameterCASM starts the Oracle Cluster Synchronization Services （CSS） daemon if it is not startedDASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
单选题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？（）AThe rebalancing of the disk group would be stopped.BThe rebalancing of the disk group would be completed as fast as possible.CThe command would result in an error because the value of POWER cannot be 0.DThe rebalancing of the disk group would be completed without affecting the disk group DG3.EThe command would result in an error because the disk groups cannot be manually rebalanced.
单选题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.
单选题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 valueB only the ASM_POWER_LIMIT initialization parameter is set to an invalid valueC only the LARGE_POOL_SIZE initialization parameter is set to an invalid valueD both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values
单选题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.
单选题Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record thestatus of the operation?（）AADD DIRECTORYBDROP DISKCRESIZE DISKDREBALANCEEADD FAILGROUP
单选题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_TYPEB DB_UNIQUE_NAMEC ASM_DISKSTRINGD ASM_POWER_LIMIT
单选题Which statement is true about the Manageability Monitor （MMON） background proces（）AIt transfers statistics from memory to disk at regular intervals.BIt coordinates the rebalance activity for disk groups when ASM is used.CIt communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.DIt performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.
单选题What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?（）AThe number of DBWR processes increasesBThe number of ASMB processes increasesCThe number of DBWR_TO_SLAVES increasesDThe rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead