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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories >> Software >> Databases >> Oracle >> Architecture
 
 


 

Back to Questions Page
 
Question
What is Dedicated Server Configuration?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
In a Dedicated Server Configuration a Server Process handles
requests for a Single User Process
 
0
Siva.k
 
 
Question
What are the functions of SMON?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
smon is background process in a sga.
its name is system monitor.function is monitering the system
its used for database recovery when database is crash.
 
0
Ankur Aggarwal
 
 
Answer
smon is used for rolling forward the committed data and 
rolling back the rollback data.smon writes commited data 
from log buffer to data files.
 
0
Pravin Pardeshi
 
 
 
Question
What is the function of ARCH?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
its a background process.its used when archive log parameter
enabled.its making archive file.archive file is a replica 
of redolog file.
 
0
Ankur Aggarwal
 
 
Question
What is Shared SQL Area?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
A Shared SQL area is required to process every unique SQL 
statement submitted to a database and contains information
such as the parse tree and execution plan for the
corresponding statement. 
 
0
Siva.k
 
 
Question
What is a Multi-threaded Server Configuration?
Rank Answer Posted By  
 Question Submitted By :: Guest
I also faced this Question!!   © ALL Interview .com
Answer
In a Multi-threaded Server Configuration many user processes
share a group of server process. 
 
0
Siva.k
 
 
 
Back to Questions Page
 
 
 
 
 
   
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