Topic : Tablespace Management

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


  • DBA_EXTENTS
  • V$FREESPACE
  • DBA_FREE_SPACE
  • DBA_TABLESPACE
  • DBA_FREE_EXTENTS

Answer :

DBA_FREE_SPACE

Show Answer Discuss

Which method increase the size of a tablespace?


  • Add a datafile to a tablespace.
  • Use the ALTER TABLESPACE command to increase the MINEXTENTS for the tablespace.
  • Use the ALTER TABLESPACE command to increase the MAXEXTENTS for the tablespace.
  • Use the ALTER TABLESPACE command to increase the MINIMUM EXTENT for the tablespace.

Answer :

Add a datafile to a tablespace.

Show Answer Discuss

Can you drop objects from a read-only tablespace?


  • No
  • Yes
  • Only when using the DBA role
  • Only when the tablespace is online

Answer :

Yes

Show Answer Discuss

SYSTEM TABLESPACE can be made off-line.


  • Yes
  • No

Answer :

No

Show Answer Discuss

Data dictionary can span across multiple Tablespaces.


  • TRUE
  • FALSE

Answer :

FALSE

Show Answer Discuss