🎴 Flashcard Mode
Oracle Database Fundamentals and SQL
Card1 / 20
Mastered0
Review0
QuestionClick to flip
What conditions have to be met before dropping a tablespace?
AnswerClick to flip back
A
The tablespace cannot have active segments
💡 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.