Oracle
1Z0-068 · Question #107
1Z0-068 Question #107: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-068 to reveal the answer and full explanation for question #107. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-068 to see the answer
You've previewed enough free 1Z0-068 questions. Unlock 1Z0-068 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.