Multiple choice technology programming languages

A Cartesian product is returned when

  1. join conditions are not specified in a PROC SQL join.

  2. join conditions are not specified in a PROC SQL set operatio

  3. more than two tables are specified in a PROC SQL join.

  4. the keyword ALL is used with the OUTER UNION operator.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A Cartesian product occurs when a PROC SQL join is specified without a WHERE clause condition to link the tables, causing every row from one table to combine with every row from the other. Set operations like OUTER UNION operate on rows differently and don't produce Cartesian products.

Keep practicing — related questions