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

题目

单选题

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？（）

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

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

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

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

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

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

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

第2题：

You work as a database administrator at Certkiller .com. 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

正确答案:A

第3题：

Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()

A. When two-way disk mirroring is required for the allocation units

B. When three-way disk mirroring is required for the allocation units

C. When using hardware mirroring or RAID

D. When disk mirroring is required for the Automatic Storage Management (ASM) disks

参考答案：C

第4题：

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.

正确答案:C

第5题：

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.

正确答案:A

第6题：

Examine the CREATE DISKGROUP command used to create a disk group:SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCYDISK ‘ORCL: FRA3‘ NAME misc1, ‘ORCL: FRA4‘ NAME misc2;In which situation would you use this method of disk group creation?（）

A. When two-way disk mirroring is required for the allocation units

B. When three-way disk mirroring is required for the allocation units

C. When using hardware mirroring or RAID

D. When disk mirroring is required for the Automatic Storage Management (ASM) disks

参考答案：C

第7题：

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.

正确答案:C

第8题：

You are maintaining the SALES database.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 should you specify to control the speed of the rebalancing activity?（）

A. ASM_POWER_LIMIT

B. ASM_DISKSTRING

C. ASM_DISKGROUPS

D. INSTANCE_TYPE

参考答案：A

第9题：

A、ASM_POWER_LIMIT
B、ASM_DISKSTRING
C、ASM_DISKGROUPS
D、INSTANCE_TYPE

正确答案:A

第10题：

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

正确答案:A

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

题目

相似问题和答案

更多相关问题

相关内容