ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Architecture
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question
What is the functionality of SYSTEM table space ?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the functionality of SYSTEM table space ?
Answer
# 1
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 ?    0 Yes 0 No
Ankur Aggarwal
 
  Re: What is the functionality of SYSTEM table space ?
Answer
# 2
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
Vivek
 
 
 

 
 
 
Other Architecture Interview Questions
 
  Question Asked @ Answers
 
How to find the current session sid  2
What is hit ratio ?  1
What is the function of checkpoint(CKPT)?  1
What is dictionary cache ?  2
What is meant by recursive hints ?  1
Why query fails sometimes ?  1
What does LGWR do?  1
What is the function of Lock (LCKn) Process?  1
What are functions of PMON?  4
What is meant by free extent ?  2
When does LGWR write to the database?  3
what is the role of archiever Satyam1
what is ORACLE MEMORY STRUCTURES  1
When Does DBWR write to the database?  4
What is a Multi-threaded Server Configuration?  1
What is meant by redo log buffer ?  1
What Does DBWR do?  2
When will be a segment released?  1
How will you force database to use particular rollback segment?  1
What is the maximum number of Lock Processes used?  1
 
For more Architecture Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com