You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task？（）

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

单项选择题You have a disk group， DGROUP1， with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group：  ALTER DISKGROUP dgroup1  ADD TEMPLATE my_temp  ATTRIBUTES （MIRROR FINE）；  Which statement is true？（）

A.When a file is created in DGROUP1 with the template， it would have three-way mirroring.
B.When a file is created in DGROUP1， the MY_TEMP template becomes the default template.
C.When a file is created in DGROUP1 with the template， it would have two-way mirroring and file striping.
D.When a file is created in DGROUP1 with the template， it would have three-way mirroring and file striping.
E.When a file is created in DGROUP1 with the template， it would have two-way mirroring but no file Striping.

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

单项选择题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 drop the disk group， ignoring the EXCLUDING CONTENTS option.
C.The command would result in the disk group being marked as INVALID because it cannot be dropped.
D.The command would result in the contents being moved to the parent disk group and dropping of the disk group.
E.The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.

单项选择题Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）：  CREATE TABLESPACE user_tbsp  DATAFILE ’+dgroup3（user_temp） user_files user_tbsp’ SIZE 200M；  What would be the result of this command？（）

A.It would result in an error because the template cannot be used along with the disk group.
B.It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
C.It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.
D.It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.