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_tbspDATAFILE ‘+dgroup3(usder_temp)/user_files/user_tbsp’ SIZE 200M;What would be the result of this command?

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(usder_temp)/user_files/user_tbsp’ SIZE 200M;
What would be the result of this command?

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(usder_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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *