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

题目
单选题
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.

相似考题

1.You want to perform the following operations for the DATA ASM disk group:Which command accomplishes these tasks?()A. ALTER DISKGROUP data CHECK;B. ALTER DISKGROUP data CHECK DISK;C. ALTER DISKGROUP data CHECK FILE;D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

2.Which two commands never trigger an implicit rebalancing within the disk group?（） (Choose two.)A、ALTER DISKGROUP misc MOUNT;B、ALTER DISKGROUP misc DROP DISK misc2;C、ALTER DISKGROUP misc CHECK ALL NOREPAIR;D、ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;E、ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';

3.You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）A、Immediately following statement execution B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued C、After the ALTER TABLE SET UNUSED COLUMN command is issued D、After the ALTER TABLE MODIFY command is issued

4.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.

更多“After executing the command alter diskgroup disk group2 drop”相关问题

  • 第1题：

    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.

    正确答案:D

  • 第2题：

    In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective：  DROP DISKGROUP dgroup1 EXCLUDING CONTENTS；  What would be the result of this command？（）

    • A、 This command would result in an error because the disk group is not empty.
    • B、 The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
    • C、 The command would result in the contents being moved to the parent disk group and dropping of the disk group.
    • D、 The command would result in the disk group being marked as INVALID because it cannot be dropped.
    • E、 The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.

    正确答案:A

  • 第3题：

    You want to perform the following operations for the DATA ASM disk group： -Verify the consistency of the disk.  -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly.  -Check that ASM metadata directories do not have unreachable allocated blocks.   Which command accomplishes these tasks（）？

    • A、 ALTER DISKGROUP data CHECK
    • B、 ALTER DISKGROUP data CHECK DISK
    • C、 ALTER DISKGROUP data CHECK FILE
    • D、 ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1

    正确答案:A

  • 第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 completed
    • 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

    正确答案:A

  • 第5题：

    单选题
    How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has alreadycompleted?（）
    A

    Issue the ALTER DISKGROUP ... ADD DISK command.

    B

    Issue the ALTER DISKGROUP ... UNDROP DISKS command.

    C

    Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.

    D

    Retrieve the disk from the Recycle Bin after the operation completes


    正确答案： B
    解析： 暂无解析

  • 第6题：

    单选题
    How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yetcompleted?（）
    A

    Issue the ALTER DISKGROUP ... ADD DISK command.

    B

    Issue the ALTER DISKGROUP ... UNDROP DISKS command.

    C

    Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.

    D

    Retrieve the disk from the Recycle Bin after the operation completes.


    正确答案： D
    解析： 暂无解析

  • 第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.


    正确答案： E
    解析： 暂无解析

  • 第8题：

    单选题
    In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective：  DROP DISKGROUP dgroup1 EXCLUDING CONTENTS；  What would be the result of this command？（）
    A

     This command would result in an error because the disk group is not empty.

    B

     The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.

    C

     The command would result in the contents being moved to the parent disk group and dropping of the disk group.

    D

     The command would result in the disk group being marked as INVALID because it cannot be dropped.

    E

     The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.


    正确答案： D
    解析： 暂无解析

  • 第9题：

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


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    You want to perform the following operations for the DATA ASM disk group： -Verify the consistency of the disk.  -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly.  -Check that ASM metadata directories do not have unreachable allocated blocks.   Which command accomplishes these tasks（）？
    A

     ALTER DISKGROUP data CHECK

    B

     ALTER DISKGROUP data CHECK DISK

    C

     ALTER DISKGROUP data CHECK FILE

    D

     ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1


    正确答案： B
    解析： 暂无解析

  • 第11题：

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


    正确答案： A
    解析： 暂无解析

  • 第12题：

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


    正确答案： D
    解析： 暂无解析

  • 第13题：

    Consider the following configuration：   /devices/diskP1 is a member of disk group grp1.        /devices/diskP2 is a member of disk group grp1.        /devices/diskP3 is a member of disk group grp1.        /devices/diskP4 is a candidate disk.        /devices/diskQ1 is a member of disk group grp2.        /devices/diskQ2 is a member of disk group grp2.        /devices/diskQ3 is a member of disk group grp2.        /devices/diskQ4 is a candidate disk.   Which command will add the disk /devices/diskP4 to the disk group， grp1？（）  

    • A、 ALTER DISKGROUP grp1  ADD DISK ’/devices/diskP1’，  ADD DISK ’/devices/diskP4’；
    • B、 ALTER DISKGROUP grp1  ADD DISK ’/devices/disk*4’；
    • C、 ALTER DISKGROUP grp1  ADD DISK ’/devices/diskP*’；
    • D、 ALTER DISKGROUP grp1  ADD DISK ’/devices/diskQ*’，  ADD DISK ’/devices/diskP*’；

    正确答案:C

  • 第14题：

    Which two commands never trigger an implicit rebalancing within the disk group?（）

    • A、ALTER DISKGROUP misc MOUNT;
    • B、ALTER DISKGROUP misc DROP DISK misc2;
    • C、ALTER DISKGROUP misc CHECK ALL NOREPAIR;
    • D、ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
    • E、 ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';

    正确答案:A,C

  • 第15题：

    How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed？（）  

    • A、 Issue the ALTER DISKGROUP ... ADD DISK command.
    • B、 Issue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command.
    • C、 Issue the ALTER DISKGROU
    • D、 Retrieve the disk from the Recycle Bin after the operation completes.

    正确答案:A

  • 第16题：

    Which two commands never trigger an implicit rebalancing within the disk group？（） 

    • A、 ALTER DISKGROUP misc MOUNT
    • B、 ALTER DISKGROUP misc DROP DISK misc2
    • C、 ALTER DISKGROUP misc CHECK ALL NOREPAIR
    • D、 ALTER DISKGROUP misc RESIZE ALL SIZE 1023m
    • E、 ALTER DISKGROUP dgroupA ADD DISK ’/devices/A*’

    正确答案:A,C

  • 第17题：

    单选题
    How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed？（）
    A

     Issue the ALTER DISKGROUP ... ADD DISK command.

    B

     Issue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command.

    C

     Issue the ALTER DISKGROU

    D

     Retrieve the disk from the Recycle Bin after the operation completes.


    正确答案： B
    解析： 暂无解析

  • 第18题：

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

    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


    正确答案： E
    解析： 暂无解析

  • 第19题：

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


    正确答案： C
    解析： 暂无解析

  • 第20题：

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


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    Consider the following configuration：   /devices/diskP1 is a member of disk group grp1.        /devices/diskP2 is a member of disk group grp1.        /devices/diskP3 is a member of disk group grp1.        /devices/diskP4 is a candidate disk.        /devices/diskQ1 is a member of disk group grp2.        /devices/diskQ2 is a member of disk group grp2.        /devices/diskQ3 is a member of disk group grp2.        /devices/diskQ4 is a candidate disk.   Which command will add the disk /devices/diskP4 to the disk group， grp1？（）
    A

     ALTER DISKGROUP grp1  ADD DISK ’/devices/diskP1’，  ADD DISK ’/devices/diskP4’；

    B

     ALTER DISKGROUP grp1  ADD DISK ’/devices/disk*4’；

    C

     ALTER DISKGROUP grp1  ADD DISK ’/devices/diskP*’；

    D

     ALTER DISKGROUP grp1  ADD DISK ’/devices/diskQ*’，  ADD DISK ’/devices/diskP*’；


    正确答案： C
    解析： 暂无解析

  • 第22题：

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


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed？（）
    A

     Issue the ALTER DISKGROUP ... ADD DISK command.

    B

     Issue the ALTER DISKGROUP ... UNDROP DISKS command.

    C

     Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.

    D

     Retrieve the disk from the Recycle Bin after the operation completes.


    正确答案： A
    解析： 暂无解析

  • 第24题：

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


    正确答案： D
    解析： 暂无解析

相关内容