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   SiteMap shows list of All Categories in this site.
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 
List the Optional Flexible Architecture (OFA) of Oracle 
database ?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: List the Optional Flexible Architecture (OFA) of Oracle database ?
Answer
# 1		 
SYSTEM - Data dictionary tables.
DATA  - Standard operational tables.
DATA2- Static tables used for standard operations
INDEXES - Indexes for Standard operational tables.
INDEXES1 - Indexes of static tables used for standard
operations.
TOOLS - Tools table.
TOOLS1 - Indexes for tools table.
RBS - Standard Operations Rollback Segments,
RBS1,RBS2 - Additional/Special Rollback segments.
TEMP - Temporary purpose tablespace
TEMP_USER - Temporary tablespace for users.
USERS - User tablespace.
 
Is This Answer Correct ?    0 Yes 0 No
Orawhiz
 

 
 
 
Other Architecture Interview Questions
 
  Question Asked @ Answers
 
What is the functionality of SYSTEM table space ?  2
What is Database Buffers ?  2
what is the role of archiever Satyam1
What Does DBWR do?  2
What is Server Process?  1
Which parameter in Storage clause will reduce no. of rows per block?  1
How will you monitor rollback segment status ?  1
What is the OPTIMAL parameter ? TCS1
How does Space allocation table place within a block ?  1
What is advantage of having disk shadowing/ Mirroring ?  1
What is Cursor?  2
What is the function of Dispatcher (Dnnn)?  2
Why query fails sometimes ?  1
What is a Multi-threaded Server Configuration?  1
What is meant by redo log buffer ?  1
What is User Process?  1
What constitute an ORACLE Instance?  2
what is ORACLE MEMORY STRUCTURES  1
How will you create multiple rollback segments in a database ?  1
What is the function of checkpoint(CKPT)?  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