Multiple choice technology programming languages

What is the output of proc sql; title ’Table One and Table Two’; select * from one, two; Table One X Y ------- 1 2 2 3 Table Two X Z ------- 2 5 3 6 4 9

  1. Table One and Table Two X Y X Z ------------ 1 2 2 5 1 2 3 6 1 2 4 9 2 3 2 5 2 3 3 6 2 3 4 9

  2. Table One and Table Two X Y X Z ------------ 1 2 2 5 2 3 2 5

  3. Table One and Table Two X Y Z ------------ 1 2 5 2 3 5

  4. Table One and Table Two X Y Z ------------ 1 2 . 2 3 5
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The query performs a Cartesian product (cross join) of tables ONE and TWO because no WHERE clause joins them. Table ONE has 2 rows (X=1,Y=2 and X=2,Y=3) and Table TWO has 3 rows (X=2,Z=5, X=3,Z=6, X=4,Z=9). The result is 2 × 3 = 6 rows, combining each row from ONE with each row from TWO. Option A shows all 6 rows correctly.

Keep practicing — related questions