Describe SQL Joins
Javasearch.buggybread.com
Share

Search Interview Questions


 3361 questions in repository.
 There are more than 200 unanswered questions.
Click here and help us by providing the answer.
 Have a video suggestion.
Click Correct / Improve and please let us know.
Label / Company      Label / Company / Text

   



Java - Interview Questions and Answers

 Q1. Describe SQL JoinsDatabase2018-02-08 00:11:24

Ans. Oracle having following types of joins these are also called 8i joins. There are:

1. Equi (or) Inner join
2. Non Equi join
3.Self join
4.Outer join

Oracle also support the 9i (or) ANSI standard joins.There are:

1.Inner join
2.Left outer join
3.Right outer join
4.Full outer join
5.Natural join

 Help us improve. Please let us know the company, where you were asked this question :   

   Like         Discuss         Correct / Improve     sql joins  sql     Asked in 2 Companies


Related Questions

 If Table A has 100 records and Table B has 50 records , how many records will the left join of Table A with Table B generate ?
 If Table A has 100 records and Table B has 50 records , how many records will the right join of Table A with Table B generate ?
 If Table A has 0 records and Table B has 50 records , how many records will the equi join of Table generate ?




Subscribe to Java News and Posts. Get latest updates and posts on Java from Buggybread.com
Enter your email address:
Delivered by FeedBurner



comments powered by Disqus
 

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.

Any input from you will be highly appreciated and It will unlock the application for 10 more requests.

Company Name:
Questions Asked:
         

X Close this