Database - Advanced SQL - Discussion

Discussion :: Advanced SQL - General Questions (Q.No.2)

2. 

What type of join is needed when you wish to return rows that do have matching values?

[A]. Equi-join
[B]. Natural join
[C]. Outer join
[D]. All of the above.

Answer: Option D

Explanation:

No answer description available for this question.

Rajkumar said: (Apr 6, 2011)  
Non equi-join is return rows that do have matching values.

Sapna said: (Dec 23, 2011)  
Yes the right answer is equi join.

Ranga said: (Dec 29, 2011)  
Equi join is correct

Rishabh said: (Aug 19, 2012)  
Equi-join both side same value then you used simple join.

Kala said: (Dec 16, 2013)  
Equi join is correct. Outer join gives non matching values. Equi join gives matching values.

Hema said: (Jan 8, 2014)  
Equi join is the correct one for match values.

Amol said: (Aug 19, 2014)  
"all of the above" is correct answer because. Outer join returns the row having matching as well as non matching values.

Habtamu said: (Nov 19, 2014)  
@Amol

From the 4 choice which one is more answerable?

Binay said: (Dec 16, 2014)  
Can you explain in detail?

Pachi said: (Sep 25, 2016)  
Yes, option D is right one. Because also outer join return matching rows from both tables.

Alelign said: (Dec 31, 2016)  
Yes, the correct answer is D because outer join returns both values that have the same and different values.

Sakhile said: (Aug 24, 2018)  
How it should be D? Please explain the answer to me.

Narasimhulu said: (Dec 17, 2019)  
The correct answer is C, Outer join returns the row having matching as well as non-matching values.

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.