Multiple choice technology programming languages

Bonus dataset ID Bonus 123 5000 456 7000 744 3500 Salary Dataset ID Salary 123 70000 456 80000 978 55000 Given the PROC SQL query and tables shown below, which output is generated? proc sql; select s.*, bonus from bonus as b right join salary as s on b.id= s.id;

  1. ID Salary Bonus 123 70000 5000 456 80000 7000 978 55000 3500

  2. ID Salary Bonus 123 70000 5000 456 80000 7000 744 . 3500

  3. ID Salary Bonus 123 70000 5000 456 80000 7000 744 55000 3500

  4. ID Salary Bonus 123 70000 5000 456 80000 7000 978 55000 .
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A right join preserves all rows from the right table (salary), which contains IDs 123, 456, and 978. The bonus table only has matching values for IDs 123 and 456, leaving ID 978 with a null (missing) bonus value in the output.

Keep practicing — related questions