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 atablespace in a
disk group.

C.
It would create atablespace with a data file that has an alias, and its attributes are set by the
user-defined template.

D.
It would create atablespace 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 *