多选题Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.

第1题：

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.

第2题：

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

第3题：

You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch.  What do you do？（）  

• A、 Take the whole disk group offline and wait for the controller card to be installed. Once it’s installed，bring the disk group online again.
• B、 Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced，reset the parameter to  its original value.
• C、 You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced， add the disk back into the disk group and allow ASM to rebuild it.
• D、 If you are using any setting other than REDUNDANCY EXTERNAL for your disk group，you will have to recover any data on that disk from a backup. The database will be unavailable until you can  correct the problem and perform recovery.
• E、 Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.

第4题：

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.

第5题：

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.

第6题：

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

• 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 database Instance.
• D、It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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.

第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

第15题：

You are the Database Administrator for WonderWeb， which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications， you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group， Automatic Storage Management （ASM） rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity， resulting in the movement of data extents in the disk groups？（）  

• A、 ASMB
• B、 ARBn
• C、 RBAL in the ASM instance
• D、 RBAL in the database instance

第16题：

Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal. Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks?（）

• A、Define the POWER option while adding or removing the disks
• B、Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.
• 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

第17题：

Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（） 

• A、 You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
• B、 You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
• C、 You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
• D、 You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.

第18题：

Immediately after adding a new disk to or removing an existing disk from an Automatic StorageManagement （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 process

第19题：

第20题：

第21题：

第22题：

第23题：