December2015 cs Q60

0. 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 SQ₁ and SQ₂ :
SQ₁ : Select * From R Full Join S On R.B = S.B;
SQ₂ : Select * From R Inner Join S On R.B = S.B;
The numbers of tuples in the result of the SQL query SQ₁ and the SQL query SQ₂ are given by:

Answer
Comment
Array

Option : 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.

You must be logged in to post a comment.

You must be logged in to post a comment.

Forgot your password?

I agree with the Terms.