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   interview questions urls   External Links  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 
Name the ORACLE Background Process?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Name the ORACLE Background Process?
Answer
# 1		 
pmon, smon, dbwr, lgwr, ckpt, arch, disp,cjq and more...
 
Is This Answer Correct ?    3 Yes 0 No
Ravi Dutta
 
  Re: Name the ORACLE Background Process?
Answer
# 2		 
there aretwo types of oracle background process
1.mandatory background process
  DBWn,PMON,SMON,LGWR and  CKPT
2.optional Background process
  ARCn,CJQ0,LMS,Dnnn,Pnnnn,Snnn,LCKn,RECO etc.
 
Is This Answer Correct ?    3 Yes 1 No
Shareef
 
 
 

 
 
 
Other Architecture Interview Questions
 
  Question Asked @ Answers
 
When does LGWR write to the database?  2
What are the components of SGA?  2
What is Database Buffers ?  2
What constitute an ORACLE Instance?  2
What do Redo Log Buffers contain?  1
How will you estimate the space required by a non-clustered tables?  1
How can we plan storage for very large tables ?  1
What is meant by redo log buffer ?  1
What is meant by Redo Log file mirrorring ? How it can be achieved?  1
What Does DBWR do?  2
What is meant by free extent ?  2
Why query fails sometimes ?  1
what is ORACLE MEMORY STRUCTURES  1
Which parameter in Storage clause will reduce no. of rows per block?  1
How does Space allocation table place within a block ?  1
What does LGWR do?  1
What is Cursor?  2
What is a Rollback segment entry ? TCS3
What is the function of Dispatcher (Dnnn)?  2
What is use of Rollback Segments In Database ?  2
 
For more Architecture Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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