Which two statements are required for this command to s…

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

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *