Oracle
1Z0-043 · Question #154
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…
The correct answer is C. It would create a tablespace with a data file that has an alias, and its attributes are set by the. See the full explanation below for the reasoning.
Question
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?
Options
- AIt would result in an error because the template cannot be used along with the disk group.
- BIt would result in an error because the path cannot be specified while creating a tablespace in a
- CIt would create a tablespace with a data file that has an alias, and its attributes are set by the
- DIt would create a tablespace with a data file that does not have an alias, and its attributes are
How the community answered
(56 responses)- A2% (1)
- B11% (6)
- C82% (46)
- D5% (3)
Community Discussion
No community discussion yet for this question.