Oracle
1Z0-072 · Question #7
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…
The correct answer is A. The INCLUDING CONTENTS AND DATAFILES clause must be added to the command. See the full explanation below for the reasoning.
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.
How the community answered
(42 responses)- A81% (34)
- B2% (1)
- C2% (1)
- D10% (4)
- E5% (2)
Community Discussion
No community discussion yet for this question.