hiexam
oracle · 1z0-068 · Q604 · multiple_response · topic_1

Examine this command: SQL> ALTER TABLESPACE TBS1 ADD DATAFILE '+DATA(newtemplate)/ORCL/USERS/mytab.dbf' SIZE 100M; Whic…

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.
Explanation
BE is correct ans

Reference: examtopics_top_comment

Practice with progress tracking

Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.