🎴 Flashcard Mode
Oracle Database Administration and Networking
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Examine the statement : DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES; What is the result of the statement?
AnswerClick to flip back
A
The contents and data files belonging to the IND2 tablespace are dropped.
💡 Explanation:
The 'INCLUDING CONTENTS AND DATAFILES' clause drops the tablespace, its schema objects, and deletes the associated physical operating system data files, regardless of whether they are Oracle-Managed Files.