Which is required to ensure that TBS1 is dropped and its datafiles are deleted from their file system?

TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF).
Examine this command:

Which is required to ensure that TBS1 is dropped and its datafiles are deleted from their file system?
A. The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.
B. TBS1 must be placed in READ ONLY state.
C. Objects in TBS1 must not be in use when the command is executed.
D. TBS1 must not contain any temp files.
E. DB_CREATE_FILE_DEST must refer to an Oracle Automatic Storage Management (ASM)disk group.

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.