SAS Certification Prep Guide, 4th Edition

Quiz

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

1. Which of the following creates an index on the column EmpID for the table Sasuser.Staffmaster?

   1. proc sql;
         create simple index(empid) 
            on sasuser.staffmaster;

   2. proc sql;
         create empid index 
            on sasuser.staffmaster(empid);

   3. proc sql;
         create simple index 
            on empid from sasuser.staffmaster;

   4. proc sql;
         create index empid 
            on sasuser.staffmaster(empid);

2. Which keyword must you add to your index definition in the CREATE INDEX statement to ensure that no duplicate values of the key column can exist?

   1. KEY
   2. UNIQUE
   3. NODUPS
   4. NODUPKEY
3. Which of the following creates a composite index ...