Multiple choice technology databases

You want to drop the TBSI tablespace from your database. You also want to delete corresponding data files automatically, and not have to do it manually. What should you do ?

  1. User the DROP DATAFILE command.

  2. Use the DROP TABLESPACE command.

  3. Ensure that all database files are Oracle Managed Files(OMF) before using the DROP TABLESPACE command.

  4. Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The DROP TABLESPACE command with the INCLUDING CONTENTS AND DATAFILES clause will automatically delete the data files. However, if Oracle Managed Files (OMF) is configured, the data files are automatically deleted without needing the DATAFILES clause. Option A's command doesn't exist. Option C would work but is more specific than needed. Option D is related to OMF configuration but not directly the solution.

Keep practicing — related questions