网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
考题
Observe the structure of the table employees:The table contains 8475 records.One of the employees wants to know the names of all employees of the company. For this, he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?（）A. Rollback segmentB. Temporary segmentC. Data segmentD. Index segment
考题
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 two statements are true about variable extent size support for large ASM files?()
A. The metadata used to track extents in SGA is reduced.B. Rebalance operations are completed faster than with a fixed extent sizeC. An ASM Instance automatically allocates an appropriate extent size.D. Resync operations are completed faster when a disk comes online after being taken offline.E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.
考题
You are creating a Windows Communication Foundation （WCF） service that implements operations in a RESTful manner.You need to add a delete operation. You implement the delete method as follows. string void DeleteItems（string id）；You need to configure WCF to call this method when the client calls the service with the HTTP DELETE operation. What should you do？（）A、 Add the WebInvoke（UriTemplate = "/Items/{id}"，Method="DELETE"） attribute to the operation.B、 Add the HttpDelete attribute to the operation.C、 Replace the string parameter with a RemovedActivityAction parameter.D、 Replace the return type with RemovedActivityAction.
考题
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
考题
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
考题
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
考题
单选题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
考题
单选题By regulation, cargo tanks must be inert before and during what operation?（）.A
StrippingB
LoadingC
CleaningD
Crude oil washing
考题
单选题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
考题
单选题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
考题
单选题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
考题
单选题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
考题
单选题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.
热门标签
最新试卷