网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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.


参考答案

参考解析
解析: 暂无解析
更多 “单选题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.” 相关考题
考题 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;

考题 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 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.

考题 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

考题 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.

考题 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.

考题 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.

考题 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.

考题 As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query?() SQL select group_number, name, state from v$ASM_DISKGROUP;  GROUP_NUMBER NAME STATE  0 DGROUP1 DISMOUNTED  2 DGROUP2 MOUNTED  3 DGROUP3 MOUNTED  A、 The DGROUP1 disk group was unmounted by another DBA.B、 A datafile has been lost, causing the ASM disk group DGROUP1 to go into the DISMOUNTED stateC、 One of the redundant disks (DGROUP1) has been lost in a disk group.D、 This query has no meaning in an ASM instance.E、 A disk associated with a disk group was discovered after the ASM instance initially opened.

考题 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.

考题 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 DISKGROUD、 Retrieve the disk from the Recycle Bin after the operation completes.

考题 You issued the following command to mount the DATA disk group in restricted mode:   ALTER DISKGROUP data MOUNT RESTRICT;   What is the implication of this command?()A、 The client RDBMS instance can access the file as a read-only file.B、 A new disk cannot be added to a disk group.C、 A disk in a disk group can be taken offline.D、 The client RDBMS instance cannot access the files in the disk group.

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

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

考题 单选题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 DISKGROUD  Retrieve the disk from the Recycle Bin after the operation completes.

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

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

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

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

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

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

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

考题 单选题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,disk5B  ALTER DISKGROUP dg1 UNDROPC  ALTER DISKGROUP dg1 UNDROP DISKSD  You cannot cancel the pending disk drops

考题 单选题You issued the following command to mount the DATA disk group in restricted mode:   ALTER DISKGROUP data MOUNT RESTRICT;   What is the implication of this command?()A  The client RDBMS instance can access the file as a read-only file.B  A new disk cannot be added to a disk group.C  A disk in a disk group can be taken offline.D  The client RDBMS instance cannot access the files in the disk group.

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