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                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
   
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle General
 
 


 

 
 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
Whatz the main diff between Subquery and a Join
 Question Submitted By :: Manam
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Whatz the main diff between Subquery and a Join
Answer
# 1
their should be a relationship between the tables then only 
we can use join conditions....
But the subquery can be used to retrive data from one or 
more table if their is no relation between the tables....
 
Is This Answer Correct ?    59 Yes 18 No
Rajesh
 
  Re: Whatz the main diff between Subquery and a Join
Answer
# 2
Majorly subqueries  run independently and result of the
subquery used in the outer query(other than corelated subquery).
And in case of join a query only give the result when the
joining condition gets satisfied.
 
Is This Answer Correct ?    27 Yes 5 No
Pardeep Chadha
 
 
 
  Re: Whatz the main diff between Subquery and a Join
Answer
# 3
Join:
It is the method of joining one or more tables together and 
finding a answer.

Sub Query:

It is a method of finding one answer using another query.

Main Difference:

In join both the tables should have a comman column name
but in subquery without having a column name we can execute 
the query.
 
Is This Answer Correct ?    25 Yes 13 No
Mythili
 
  Re: Whatz the main diff between Subquery and a Join
Answer
# 4
Join:
It is the machanism of joining one or more tables together 
and finding information from one or all tables used in join.

Sub Query:

It is a method of finding answer using another query as 
parametere for first query.

Main Difference:

In join both the tables should have a comman column type
but in subquery without having a column type we can execute 
the query.
 
Is This Answer Correct ?    13 Yes 10 No
Kuldeep Singh
 
  Re: Whatz the main diff between Subquery and a Join
Answer
# 5
Sub Query:

The Sub Query only get the results as one table or the 
other table based that the result be of onther table as 
used in the table.
The two tables information are dispalyed as combiend.

Join:
 
To get results more rhan two tables information.
 
Is This Answer Correct ?    3 Yes 2 No
Siva
 
  Re: Whatz the main diff between Subquery and a Join
Answer
# 6
their should be a relationship between the tables then only 
we can use join conditions....
But the subquery can be used to retrive data from one or 
more table if their is no relation between the tables....
 
Is This Answer Correct ?    12 Yes 0 No
Anbu
 
  Re: Whatz the main diff between Subquery and a Join
Answer
# 7
The main difference between join and sub query is :
join is used to retrieve data from two different tables 
where as in sub query we can retreive data from one table 
using the result of the where condition on another table.
 
Is This Answer Correct ?    5 Yes 7 No
A.n.v.v.siva Kumar
 
  Re: Whatz the main diff between Subquery and a Join
Answer
# 8
join combines tables and retrieves data where as sub query 
doesn't combines two table.join is more faster than subquery
 
Is This Answer Correct ?    3 Yes 1 No
Srijina
 
  Re: Whatz the main diff between Subquery and a Join
Answer
# 9
the main diff is
 
the subquery gives the result from one table only,but whose condition may depend on another table i.e the inner query.

whereas join gives the result from both the tables if condition is satisfied
 
Is This Answer Correct ?    1 Yes 0 No
Affan
 
  Re: Whatz the main diff between Subquery and a Join
Answer
# 10
main difference between join and subqurey  is that join is
used for known condition while subquery is used for unknown
condition.
 
Is This Answer Correct ?    2 Yes 0 No
Adil Khan
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
What is Index Cluster ?  1
What is an Extent ?  2
What is a Temporary Segment ?  2
What is Database Link ?  2
After update how do u know how many records got updated TCS4
Who i will insert 1 lacks record in a Database table TCS3
How do we know whether an index is created on a table ??? TCS1
What is a Redo Log ?  2
What is a Schema ?  5
how do u know the total no of rows in a table?  5
What does a Control file Contain ?  2
Do View contain Data ?  8
 
For more Oracle 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 © 2010  ALLInterview.com.  All Rights Reserved.

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