If A Left Outer Join Is Performed And The Tuple On The Left #55
If a left outer join is performed and the tuple on the left hand side does not match with the tuple on the right hand side, what happens to the values that are preserved on the left hand side?
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.
If a left outer join is performed and the tuple on the left hand side does not match with the tuple on the right hand side, what happens to the values that are preserved on the left hand side?
They are given null values
They are given a random value
The user is asked to enter data
The query is declared invalid by the compiler
