单选题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 scr

第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 group
• B、all disks that are currently in OFFLINE mode
• C、all disks that are not currently in OFFLINE mode
• D、all disks in the disk group only if all of them are ONLINE

第2题：

You are maintaining the SALES database on Oracle 10g. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter will you specify to control the speed of the rebalancing activity？ （） 

• A、 ASM_POWER_LIMIT
• B、 ASM_DISKSTRING
• C、 ASM_DISKGROUPS
• D、 LARGE_POOL_SIZE

第3题：

第4题：

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.

第5题：

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.

第6题：

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.

第7题：

You are managing an ASM instance. You previously issued the following statements: ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5; You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue?（）

• A、ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;
• B、ALTER DISKGROUP dg1 UNDROP;
• C、ALTER DISKGROUP dg1 UNDROP DISKS;
• D、You cannot cancel the pending disk drops.

第8题：

第9题：

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

第10题：

You are a network administrator for your company. All servers run Windows Server 2003. You manage a server that functions as a file server. The data volume on the server is mirrored. Each physical disk is on a separate controller. One of the hard disks that contains the data volume fails. You discover that the failure was caused by a faulty SCSI controller. You replace the SCSI controller. You need to restore the data volume to its previous state. You need to achieve this goal by using the minimum amount of administrative effort. What should you do? （）

• A、Run the diskpart active command to activate the failed volume.
• B、Convert both disks to basic disks, and then restore the data.
• C、Break the mirror, and then re-create the mirror.
• D、Select a disk in the mirror, and then reactivate the volume.