nerdexam
SAS_Institute

A00-212 · Question #176

The SAS data set WORK.CHECK has a variable named Id_Code in it. Which SQL statement would create an index on this variable?

The correct answer is D. Create index Id_Code on WORK.CHECK. See the full explanation below for the reasoning.

Question

The SAS data set WORK.CHECK has a variable named Id_Code in it. Which SQL statement would create an index on this variable?

Options

  • ADefine index (Id_Code) in WORK.CHECK;
  • BCreate index (Id_Code) on WORK.CHECK;
  • CMake index = Id_Code from WORK.CHECK;
  • DCreate index Id_Code on WORK.CHECK;

How the community answered

(53 responses)
  • A
    4% (2)
  • B
    8% (4)
  • C
    15% (8)
  • D
    74% (39)

Community Discussion

No community discussion yet for this question.

Full A00-212 Practice