Multiple choice technology databases

Which data dictionary view shows the available free space in a certain tablespace?

  1. DBA_EXTENTS

  2. V$FREESPACE
  3. DBA_FREE_SPACE

  4. DBA_FREE_EXTENTS

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DBA_FREE_SPACE is the correct Oracle data dictionary view that displays information about free space extents within tablespaces. V$FREESPACE doesn't exist in Oracle, and DBA_EXTENTS shows allocated extents not free space.