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 is used to remove a tablespace from the database. To automatically delete the associated data files, you must include the INCLUDING CONTENTS AND DATAFILES clause. Option A mentions a non-existent DROP DATAFILE command, while options C and D describe prerequisites for automatic file deletion in Oracle Managed Files environments.

Keep practicing — related questions