Oracle Database Administration I — Question 152

TBS1 is a permanent user-defined tablespace. Oracle Managed Files (OMF) is not used in this database.

Examine this command:

DROP TABLESPACE tbsl;

Which two will ensure that TBS1 is dropped and its datafiles are deleted from the file system? (Choose two.)

Answer options

• A. TBS1 must not contain any temp files.
• B. There must be no uncommitted transactions involving segments stored in TBS1.
• C. TBS1 must be READ WRITE.
• D. The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.
• E. TBS1 must be altered READ ONLY.

Correct answer: A, D

Explanation

Option A is correct because the tablespace must not contain temporary files to be dropped successfully. Option D is also correct since the INCLUDING CONTENTS AND DATAFILES clause is necessary to ensure all datafiles are removed from the file system. The other options do not directly relate to the requirement for dropping the tablespace and deleting its datafiles.