Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 448
|
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:
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:
|
2 and 6 respectively
|
|
|
6 and 2 respectively
|
|
|
2 and 4 respectively
|
|
|
4 and 2 respectively
|
Question 448 Explanation:
Correct Answer: D
Question 448 Explanation: