Awesome q2a theme
0 votes
No. of tuples obtained as the output of an outer join (left, right or full outer join) is a superset of the no. of tuples obtained in Natural join.

Is the abv. statement TRUE or FALSE?

State with Reason.
ago in Databases by (5 points)
edited ago by | 15 views
Its true.

outer join always ensure that, unmatched rows also include in the result with NULL on other side depend upon outer join. But Natural join doesn’t.

Some times outer join may produces the result same as Natural join.

By these two, we can conclude that given statement is correct.

Please log in or register to answer this question.

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
8,953 questions
3,113 answers
95,780 users