edited by
8,911 views
31 votes
31 votes

Consider two relations $R_1(A,B)$ with the tuples $(1,5), (3,7)$ and $R_2(A,C) = (1,7),(4,9)$.

Assume that $R(A,B,C)$ is the full natural outer join of $R_1$ and $R_2$. Consider the following tuples of the form $(A,B,C):$

$a = (1,5,null), b=(1,null,7), c=(3,null,9), d=(4,7,null), e=(1,5,7), $

$ f=(3,7,null),  g=(4,null,9).$

Which one of the following statements is correct?

  1. $R$ contains $a, b, e, f, g$ but not $c, d$.
  2. $R$ contains all $a, b, c, d, e, f, g$.
  3. $R$ contains $e, f, g$ but not $a, b$.
  4. $R$ contains $e$ but not $f, g$.
edited by

2 Answers

Best answer
42 votes
42 votes
$R_1(A,B): \begin{array}{|c|c|} \hline \textbf{A} & \textbf{B} \\\hline \text {1} &  \text{5 }\\\hline \text{3} & \text{7} \\\hline \end{array}$

$R_2(A,C): \begin{array}{|c|c|} \hline \textbf{A} & \textbf{C} \\\hline \text {1} &  \text{7}\\\hline \text{4} & \text{9} \\\hline \end{array}$

Now , if we do full natural outer join:
$$\begin{array}{|c|c|} \hline \textbf{A} & \textbf{B} & \textbf{C}\\\hline \text {1} &  \text{5 } & \text{7}\\\hline \text{3} & \text{7} & \text{NULL} \\\hline  \text{4} & \text{NULL} & \text{9} \\\hline \end{array}$$
So, option (C) is correct.
edited by
5 votes
5 votes
Ans C. Full outer join means take all matching rows from left table and right table based on common columns.
Answer:

Related questions

44 votes
44 votes
3 answers
2
33 votes
33 votes
4 answers
4