MCQOPTIONS
Saved Bookmarks
| 1. |
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 SOn R.B=S.B;SQ2 : Select *From R Inner Join SOn 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» E. | |