Topic : Tablespace Management

Multiple Tablespaces can share a single datafile.


  • TRUE
  • FALSE

Answer :

FALSE

Show Answer Discuss

All datafiles related to a Tablespace are removed when the Tablespace is dropped?


  • TRUE
  • FALSE

Answer :

FALSE

Show Answer Discuss

When tables are stored in locally managed tablespaces; where is extent allocation information stored?


  • Memory
  • Data Dictionary
  • Temporary tablespace
  • Corresponding tablespace itself

Answer :

Corresponding tablespace itself

Show Answer Discuss

Using which package we can convert Tablespace from DMTS to LMTS?


  • DBMS_TABLESPACE
  • DBMS_SPACE_ADMIN
  • DBMS_LOCAL_TABLESPACE

Answer :

DBMS_SPACE_ADMIN

Show Answer Discuss

Locally Managed table spaces will increase the performance?


  • TRUE
  • FLASE

Answer :

TRUE

Show Answer Discuss