Multiple choice

Which of the following can produces the NULL values in the resultant tables? Note: The source tables have no NULL values in them.

A. INNER JOIN B. LEFT & RIGHT JOINS C. SELF JOIN

  1. A

  2. B

  3. C

  4. All of the JOINS produce NULL values to every result table

  5. JOINS never produce NULL values in the result tables when the source tables have no NULL values.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Only LEFT & RIGHT JOINs produce NULL values, while joining two tables as they result the non-matching rows by filling NULL values.

Keep practicing — related questions