Open In App

UGC-NET | UGC NET CS 2015 Dec – III | Question 60

Like Article
Like
Save
Share
Report

Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 :
SQ1 : Select *
From R Full Join S
On R.B = S.B;
SQ2 : Select *
From R Inner Join S
On R.B = S.B;
The numbers of tuples in the result of the SQL query SQ1 and the SQL query SQ2 are given by:

(A) 2 and 6 respectively
(B) 6 and 2 respectively
(C) 2 and 4 respectively
(D) 4 and 2 respectively


Answer: (D)

Explanation: Full join will give two match for B = 2 and B = 4. and two mismatch So it will give 4 output.
Inner join will give output for only matching condition. B = 2 and B = 4. Two output from inner join.
So, option (D) is correct.


Quiz of this Question


Last Updated : 12 Jun, 2018
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads