SAS Certified Professional Prep Guide

Quiz

Select the best answer for each question. After completing the quiz, check your answers using the answer key in the appendix.

1. When is a Cartesian product returned?

   1. When join conditions are not specified in a PROC SQL join.
   2. When join conditions are not specified in a PROC SQL set operation.
   3. When more than two tables are specified in a PROC SQL join.
   4. When the keyword ALL is used with the OUTER UNION operator.
2. Given the PROC SQL query and tables shown below, which output is generated?

   

   proc sql;
      select *
         from certadv.store1, certadv.store2
         where store1.wk=store2.wk;
   quit;