Select the best answer
for each question. After completing the quiz, check your answers using
the answer key in the appendix.
-
When is a Cartesian
product returned?
-
When join conditions
are not specified in a PROC SQL join.
-
When join conditions
are not specified in a PROC SQL set operation.
-
When more than two tables
are specified in a PROC SQL join.
-
When the keyword ALL
is used with the OUTER UNION operator.
-
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;