单选题Examine the following command：   ALTER DISKGROUP data MOUNT FORCE；   In which scenario can you use the above command to mount the disk group？（）A  when ASM disk goes offlineB  when one or more ASM files are droppedC  when some disks in a disk group are 

第1题：

第2题：

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.

第3题：

第4题：

Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）

• A、It cancels all pending disk drops within the disk group.
• B、It restores disks that are being dropped as the result of a DROP DISKGROUP operation
• C、It mounts disks in the disk group for which the drop-disk operation has already been co pleted
• D、It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
• E、It adds previously dropped disks back into the disk group

第5题：

You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours：   ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H；   Which statement is true in this scenario？（）

• A、 It starts the ASM fast mirror resync.
• B、 All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
• C、 It drops all disk paths from the dga disk group.
• D、 All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.

第6题：

第7题：

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.

第8题：

第9题：

Examine the following command：   ALTER DISKGROUP data MOUNT FORCE；   In which scenario can you use the above command to mount the disk group？（）  

• A、 when ASM disk goes offline
• B、 when one or more ASM files are dropped
• C、 when some disks in a disk group are offline
• D、 when some disks in a failure group for a disk group are rebalancing

第10题：

You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?（）

• A、Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
• B、Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
• C、Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
• D、Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
• E、Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
• F、Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.