Topic : Tablespace Management

How often does a read-only tablespace need to be backed up?


  • At all database backups
  • Whenever the control file is recreated
  • Only once after the tablespace becomes read-only
  • When the database is put into ARCHIVELOG mode

Answer :

Only once after the tablespace becomes read-only

Show Answer Discuss

Which following statement is true when tablespaces are put in backup mode for hot backups?


  • High Volume of REDO is generated
  • No updates to tables in that tablespace
  • All of the above
  • None of the above

Answer :

High Volume of REDO is generated

Show Answer Discuss

How do you resize a data file and tablespace?


Answer :

- Prior to Oracle 7.2 you can?t resize a datafile.
- The solution was to delete the tablespace; recreating it with different sized datafiles.
- After 7.2 you can resize a datafile by using ALTER DATABASE DATAFILE RESIZE;
- Resizing

Show Answer Discuss

What does coalescing a tablespace do?


Answer :

Coalescing is only valid for dictionary-managed tablespaces and de-fragments space by combining neighboring free extents into large single extents.

Show Answer Discuss

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?


Answer :

A temporary tablespace is used for temporary objects such as sort structures while permanent tablespaces are used to store those objects meant to be used as the true objects of the database.

Show Answer Discuss