Multiple choice technology databases

A Datafile can be part of multiple tablespaces.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A datafile can belong to only one tablespace at a time. This is a fundamental Oracle storage rule - datafiles are allocated to a specific tablespace when created and cannot be shared. To use a datafile's space for another tablespace, you must drop it from the first and reassign it.

Keep practicing — related questions