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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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 
Select * from emp,dept,loc where emp.deptno left outer join 
dept.deptno and dept.locno=loc.locno.

No need to consider the syntax but is it possible to have 
left outer join and equi join in the same SQL like this ?
can we have right outer join and left outer join in the 
same SQL ---
 Question Submitted By :: Achoudhr
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
Answer
# 1		 
You can very well put Inner / Left Outer / Right Outer join 
in the same SQL Query.
 
Is This Answer Correct ?    4 Yes 0 No
Mayur
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
What are cursors?  4
Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K Accenture3
4.Explain Snowflkeschema ? HCL6
What is IQD file?  1
What is a Data Cube?  1
What is source qualifier?  1
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ? Principal-Finance3
What's a Cube in Rolap? Oracle2
what are different types of partitioning in oracle ?  2
What is confirmed dimension?  5
wht is degenerated dimension ?it's uses? CTS8
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I IBM1
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.  1
How many repositories can we create in Informatica? Informatica8
How to use the tool Ontobulider  1
Explain about Control M JObs detaily?How to execute this. Scope-International2
What is the difference between an ODS and a W/H?  1
what is a hot file, why we need in datawarehousing, where we used in general Thomson2
Compare ?Data mining? and ?Data Warehousing??  4
What is the difference between a W/H and an OLTP application?  4
 
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