Technical Discussion :: DBMS
Home > Freshers > Technical Interview Questions > DBMS
13. What is the use of system tablespace?
Answer:
SYSTEM – a tablespace that is always used to store SYSTEM data that includes data about tables, indexes, sequences, and other objects – this metadata comprises the data dictionary. Every Oracle database has to have a SYSTEM tablespace—it is the first tablespace created when a database is created.
Asked In :: Accenture
SYSTEM – a tablespace that is always used to store SYSTEM data that includes data about tables, indexes, sequences, and other objects – this metadata comprises the data dictionary. Every Oracle database has to have a SYSTEM tablespace—it is the first tablespace created when a database is created.