ALLInterview.com :: Home Page            
 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                      
Google
   
 
Categories >> Software >> Databases >> Oracle >> Architecture
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions (720)
 OCI interview questions  OCI Interview Questions (10)
 Architecture interview questions  Architecture Interview Questions (75)
 Oracle Security interview questions  Oracle Security Interview Questions (37)
 Database Management interview questions  Database Management Interview Questions (265)
 Forms Reports interview questions  Forms Reports Interview Questions (466)
 Oracle AllOther interview questions  Oracle AllOther Interview Questions (183)
Question
What is dictionary cache ?
 Question Submitted By :: Architecture
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
it is a part of shared pool which contains most recently
used dictionary data like priviledges, objects,
users,packages....
 
Is This Answer Correct ?    4 Yes 0 No
Vivek
 
Answer
# 2
it is a component of SGA. this is used to check the syntax
and the semantics of the query.
 
Is This Answer Correct ?    1 Yes 3 No
Ravi Dutta.
 
 
 

 
 
 
Other Architecture Interview Questions
 
  Question Asked @ Answers
 
How will you estimate the space required by a non-clustered tables?   2
How many Dispatcher Processes are created?   1
How can we plan storage for very large tables ?   1
What is hit ratio ? Indiabulls 8
What is Shared SQL Area? Oracle 1
How will you monitor rollback segment status ?   2
What is the function of Dispatcher (Dnnn)?   3
What does LGWR do?   2
What constitute an ORACLE Instance?   2
List the factors that can affect the accuracy of the estimations ?   1
What is a Parallel Server option in ORACLE?   1
What is the functionality of SYSTEM table space ?   3
 
For more Architecture Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com