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.)
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.)
For the command to succeed, newtemplate must be defined for the +DATA disk group to ensure that the specified template can be used to create the data file. Additionally, user-defined subdirectories ORCL and USERS must already exist because the command specifies a data file path that includes these subdirectories. If these subdirectories do not exist, the command will fail.
BE is correct ans
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.
BE could be more possible answer.