Tag: programming languages

Quizzes (351) Questions (7021)

Questions Related to programming languages

Multiple choice technology programming languages

Which of the following statements is true regarding the UNDO_POLICY=REQUIRED option?

  1. It must be used with the REQUIRED integrity constraint.

  2. It ignores the specified integrity constraints if any of the rows that you want to insert or update do not meet the constraint criteria.

  3. It restores your table to its original state if any of the rows that you try to insert or update do not meet the specified integrity constraint criteria.

  4. It allows rows that meet the specified integrity constraint criteria to be inserted or updated, but rejects rows that do not meet the integrity constraint criteria.
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
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
Full explanation
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
Full explanation
Multiple choice technology programming languages

What is the output of : data merged; merge fltsuper fltdest; by flight; run; proc print data=merged noobs; title ’Table MERGED’; run; 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 MERGED Flight Supervisor Destination 145 Kang Brussels 150 Miller Paris 155 Evanko 157 Lei 165 Seattle

  2. Table MERGED Flight Supervisor Destination 145 Kang Brussels 150 Miller Paris

  3. Table MERGED Flight Supervisor Destination 145 Kang Brussels 145 Ramirez Edmonton 150 Miller Paris 150 Picard Madrid

  4. Table MERGED Flight Supervisor Destination 145 Kang Brussels 145 Ramirez Edmonton 150 Miller Paris 150 Picard Madrid 155 Evanko 157 Lei 165 Seattle
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
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