What is the functionality of SYSTEM table space ?

Answers were Sorted based on User's Feedback



What is the functionality of SYSTEM table space ?..

Answer / ankur aggarwal

system tablespace is a main part of oracle database.All the
database information is in it.it is created when database
is created.
its managed by oracle server.dba cannot change its
containts.

Is This Answer Correct ?    3 Yes 0 No

What is the functionality of SYSTEM table space ?..

Answer / yogesh

1. Every Oracle Database Contain table space name System
which Oracle Create automatically When the Database is Created.
2. System Table space is always Open When Database is online.
3. You can Create Locally managed System table spaces.
4. System Table space is always Contained the
Data-dictionary table for the entire database.
5.It can not made Writable.

Is This Answer Correct ?    2 Yes 0 No

What is the functionality of SYSTEM table space ?..

Answer / vivek

it contains the data dictionary objects which cannot be
modified by dba with few exceptions like aud$

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Architecture Interview Questions

What are disadvanteges of having raw devices ?

1 Answers  


What are the components of SGA?

5 Answers  


Why query fails sometimes ?

1 Answers  


What is SGA?

3 Answers  


List the Optional Flexible Architecture (OFA) of Oracle database ?

1 Answers  


What is Shared SQL Area?

1 Answers   Oracle,


How many Dispatcher Processes are created?

1 Answers  


What are Oracle Schema Objects?

0 Answers  


How to implement the multiple control files for an existing database ?

2 Answers  


How can we plan storage for very large tables ?

1 Answers  


How will you create multiple rollback segments in a database ?

1 Answers  


When does LGWR write to the database?

3 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)