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  >>  Data Warehouse  >>  Data Warehouse General
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
what is query optimizer? what are different types of
optimizer s supported by oracle ?
 Question Submitted By :: Jakki
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is query optimizer? what are different types of optimizer s supported by oracle ?
Answer
# 1		 
The query optimizer is the component of a database 
management system to optimize the query. Query optimization 
is a function of many relational database management 
systems in which multiple query plans for satisfying a 
query are examined and a good query plan is identified. 


Oracle supports two different Oracle query optimizers, a 
rule-based optimizer and a cost-based optimizer. With 
Oracle Database 10g, the rule-based optimizer is 
desupported.
 
Is This Answer Correct ?    1 Yes 0 No
Subhendu
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
how can one connect two fact tables ? is it possible ? how? ABC6
what is query optimizer? what are different types of optimizer s supported by oracle ?  1
What is the difference between a W/H and an OLTP application?  4
What is an OLTP (Online Transaction Processing) System?  2
What is a Data Cube?  1
2.What is staging area ? HCL1
Difference between DSS & OLTP? IBM2
difference between bo 6.5 and bo xi r2 Accenture1
What is up date strategy and what are th options for update strategy?  2
How can we import and export using BCP utility?  1
What is factless fact schema?  1
What is a Data Warehouse?  7
What is difference between Business Objects and Hyperion Essbase? Please help me  1
what is the difference between etl tool and olap tools  3
What is subject area?  2
What is XMLA ?  1
Tell me one example for multi valued dimension or bridge table? TCS1
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ? Oracle3
What is ETL process in Data warehousing?  2
What is a look up function? What is default transformation for the look up function?  1
 
For more Data Warehouse General 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