What Is The Difference Between A Join And An Outer Join #47
What is the difference between a join and an outer join operation?
This multiple choice question (MCQ) is related to the book/course gs gs114 Relational Database Management System. It can also be found in gs gs114 Intermediate and Advanced SQL - Join Expressions - Quiz No.1.
What is the difference between a join and an outer join operation?
There is no difference
Join preserves a few tuples that are otherwise lost in the outer join
Outer join preserves a few tuples that are otherwise lost in the join
An outer join can be used only on outer queries whereas a join operation can be used in Subqueries