Oracle Database 12c: RAC Administration — Question 24

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.)

Answer options

• 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.

Correct answer: C, D

Explanation

The correct answer includes C and D because existing data files in TBS1 must share the same template to ensure compatibility, and the +DATA disk group being part of Flex ASM would prevent the addition of the datafile. Options A, B, and E are not required for the command to succeed; they pertain to configurations that are not directly necessary for this specific operation.