O'Reilly logo

SAS Certification Prep Guide, 4th Edition by SAS Institute

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required