Oracle
1Z0-072 · Question #7
1Z0-072 Question #7: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-072 to reveal the answer and full explanation for question #7. The question stem and answer options stay visible for context.
Question
TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF). Examine this command: DROP TABLESPACE TBS1; Which is required to ensure that TBS1 is dropped and its datafiles are deleted from their file system?
Options
- AThe INCLUDING CONTENTS AND DATAFILES clause must be added to the command.
- BTBS1 must be placed in READ ONLY state.
- CObjects in TBS1 must not be in use when the command is executed.
- DTBS1 must not contain any temp files.
- EDB_CREATE_FILE_DEST must refer to an Oracle Automatic Storage Management (ASM) disk group.
Unlock 1Z0-072 to see the answer
You've previewed enough free 1Z0-072 questions. Unlock 1Z0-072 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.