单项选择题
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 threeway 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 twoway mirroring and file striping.
D.When a file is created in DGROUP1 with the template， it would have threeway mirroring and file striping.
E.When a file is created in DGROUP1 with the template， it would have twoway 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. -
单项选择题
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 userdefined template.
D.It would create a tablespace with a data file that does not have an alias， and its attributes are set by the userdefined template. -
单项选择题
You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1 and DG2， with one device each. In the parameter file of the production database， the following parameters have been specified： DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’ DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’ What would be the impact of this setting？（）
A.When a new log group is added， it would have one member in each disk group.
B.When a new log group is added， it would have two members in each disk group.
C.When a new tablespace is added， it would have one data file in each disk group.
D.When a new log file is added， it would have one member spread across the disk groups.
