Multiple choice technology databases

What conditions have to be met before dropping a tablespace?

  1. The tablespace must be offline

  2. The tablespace must be online

  3. The tablespace cannot have active segments

  4. The administrator NOT needs the correct system privilege
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A tablespace can only be dropped when it has no active segments (objects) occupying space. The online/offline status of the tablespace doesn't prevent dropping. The administrator must have the DROP TABLESPACE system privilege. Option D has a double negative making it confusing.

Keep practicing — related questions