Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology programming languages

What id the output of:proc sql; title ’Table JOINED’; select * from fltsuper s, fltdest d where s.Flight=d.Flight; FLTSUPER Flight Supervisor 145 Kang 145 Ramirez 150 Miller 150 Picard 155 Evanko 157 Lei FLTDEST Flight Destination 145 Brussels 145 Edmonton 150 Paris 150 Madrid 165 Seattle

  1. Table JOINED Flight Supervisor Flight Destination ------------------------------------------- 145 Kang 145 Brussels 145 Kang 145 Edmonton 145 Ramirez 145 Brussels 145 Ramirez 145 Edmonton 150 Miller 150 Paris 150 Miller 150 Madrid 150 Picard 150 Paris 150

  2. Table JOINED Flight Supervisor Flight Destination ------------------------------------------- 145 Ramirez 145 Edmonton 150 Picard 150 Madrid

  3. Table JOINED Flight Supervisor Flight Destination ------------------------------------------- 145 Kang 145 Brussels 145 Kang 145 Edmonton 150 Miller 150 Paris 150 Miller 150 Madrid

  4. Table JOINED Flight Supervisor Flight Destination ------------------------------------------- 145 Kang 145 Brussels 145 Ramirez 145 Brussels 150 Miller 150 Paris 150 Picard 150 Paris 150 Picard 150 Madrid
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology programming languages

Which of the following PROC SQL steps gives bonuses (in points) to frequent-flyer program members as follows: - a 50% bonus for members who traveled less than 10,000 miles - a 100% bonus for members who traveled 10,000 miles or more?

  1. proc sql; update work.frequentflyers set pointsearned=pointsearned* case if milestraveled < 10000 then 1.5 if milestraveled >= 10000 then 2 else 1 end;

  2. proc sql; update work.frequentflyers set pointsearned=pointsearned* case when milestraveled < 10000 then 1.5 when milestraveled >= 10000 then 2 else 1 end;

  3. proc sql; update work.frequentflyers set pointsearned=pointsearned* case if milestraveled < 10000 then pointsearned*1.5 if milestraveled >= 10000 then pointsearned*2 else 1 end;

  4. proc sql; update work.frequentflyers set pointsearned=pointsearned* case if milestraveled < 10000 then pointsearned*1.5 if milestraveled >= 10000 then pointsearned*2 else pointsearned*1 end;
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation