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.
newtemplatemust be defined for the +DATA disk group.
C.
Existing data files inTBS1must 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.
IMO : BE
A- DB_CREATE_FILE_DEST not required while using full path
C- not mandatory
D- not relevant
B,E
C wrong
Using clauses of the ALTER DISKGROUP SQL statement, you can add new templates to a disk group, modify existing ones, or drop templates. The reason to add templates is to create the right combination of attributes to meet unique requirements. You can then reference a template name when creating a file, thereby assigning desired attributes based on an individual file rather than on the file type.