Multiple choice technology programming languages

proc sql; title ’One and Two Joined’; select one.a ’One’, one.b, two.a ’Two’, two.b from one, two where one.b=two.b; Table One a b -------- a 1 b 2 c . d 4 Table Two a b -------- a 1 b 2 c . d 4 e . f . What is the output?

  1. One and Two Joined One b Two b ------------------- a 1 a 1 b 2 b 2 d 4 d 4 c . e . c . f .

  2. One and Two Joined One b Two b ------------------- a 1 a 1 b 2 b 2 c . c . d 4 d 4 c . e . c . f .

  3. One and Two Joined One b Two b ------------------- a 1 a 1 b 2 b 2 c . c . d 4 d 4

  4. One and Two Joined One b Two b ------------------- a 1 a 1 b 2 b 2 . . . . d 4 d 4
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The query performs an inner join on column b between tables ONE and TWO. Matching rows: both have (a,1), (b,2), (c,.) with NULL/SAS missing values. The row (d,4) appears in both tables. Row (e,.) and (f,.) in table TWO don't have matches in ONE. The inner join returns all matched rows including NULL matches on the join column. Option B correctly shows all 6 matched rows.

Keep practicing — related questions