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.

单项选择题

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

单项选择题 You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry： ASM_DISKSTRING = /devices/* What could be the reason for this setting？（）

单项选择题 You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）

1z0-043