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 constitute an ORACLE Instance?

2 Answers  


How will you force database to use particular rollback segment?

1 Answers  


What is Cursor?

2 Answers   Virtusa,


Teradata: How can we know the indexed column in a table?

0 Answers   CTS, HSBC,


How will you monitor rollback segment status ?

2 Answers  


What is advantage of having disk shadowing/ Mirroring ?

1 Answers  


Why query fails sometimes ?

1 Answers  


What is the maximum number of Lock Processes used?

1 Answers  


When will be a segment released?

1 Answers  


what is ORACLE MEMORY STRUCTURES

3 Answers  


What Does DBWR do?

2 Answers   Honeywell,


What is PGA?

5 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)