Examine this command: SQL> ALTER TABLESPACE TBS1 ADD DATAFILE '+DATA(newtemplate)/ORCL/USERS/mytab.dbf' SIZE 100M; Which two statements are required for this command to succeed? (Choose two.)
A.
The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
B.
newtemplate must be defined for the +DATA disk group.
C.
Existing data files in TBS1 must also use the same template.
D.
The +DATA disk group should not be part of Flex ASM.
E.
User-defined subdirectories ORCL and USERS must already exist.
B. When specifying a template in the Oracle Managed Files (OMF) structure, the template (newtemplate) must be pre-defined within the disk group. This template contains attributes that dictate how files will be created and managed within the disk group.
E. the subdirectories ORCL and USERS must already exist within the +DATA disk group. If these subdirectories do not exist, the command will fail as it cannot create the data file in a non-existent directory structure.
A. This parameter is used to specify a default location for creating database files when no explicit location is provided. So this parameter is not relevant.
C. Existing data files do not need to use the same template for adding a new data file
D. Flex ASM (Automatic Storage Management) is related to the architecture and availability of ASM instances and does not directly affect the ability to add a data file to a tablespace in the specified manner.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
lcoleandro
2 weeks, 3 days agoYoones
2 years, 7 months agohereisash
3 years, 3 months ago