Home

Dashboard My courses

Back

Question $15$

Not yet answered Marked out of $1\mathrm{.}00$

Which statement is true for Full outer$-$join?

The left outer join adds all left relation tuples that did not match any right relation tuples to the natural join result by padding them with null values for all other attributes from the right relation.

It supplements the natural join with nulls for right$-$relation tuples that did not match left$-$relation tuples.

It pads tuples from the left and right relations that did not match and adds them to the join result.

The function adds not$-$matched tuples to the natural join result by padding them with null values for all other attributes from the right relation.

a$.3$

b$.1$

c$.2$

d$.4$ and $1$

Clear my choice

Type here to search