Oracle
1Z0-068 · Question #107
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.)
The correct answer is C. Existing data files in TBS1 must also use the same template. D. The +DATA disk group should not be part of Flex ASM. See the full explanation below for the reasoning.
Question
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.)
Options
- AThe DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
- Bnewtemplate must be defined for the +DATA disk group.
- CExisting data files in TBS1 must also use the same template.
- DThe +DATA disk group should not be part of Flex ASM.
- EUser-defined subdirectories ORCL and USERS must already exist.
How the community answered
(26 responses)- A8% (2)
- B15% (4)
- C73% (19)
- E4% (1)
Community Discussion
No community discussion yet for this question.