Multiple choice

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_TABLESPACE

  5. DBA_FREE_EXTENTS

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

DBA_FREE_SPACE is the data dictionary view that displays information about free extents available in tablespaces. Each row represents one free extent in a tablespace, showing the tablespace name, file ID, block ID, and bytes/blocks free.