📝 Question
#1258
Suppose 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)}. Then the number of tuples in the result of the SQL query: <i>SELECT * FROM R NATURAL OUTER JOIN S; </i>IS:
✓
Correct Answer
A. 2
💡
Explanation
The SQL NATURAL JOIN is a type of EQUI JOIN and is structured in such a way that, columns with same name of associate tables will appear once only.
⌨️ Press
A
B
C
D
to select