Multiple choice technology programming languages

State which of the following statement(s) are correct regarding Proc SQL?

  1. In simple index, the index name must be same as the column name.

  2. The values must be in sorted form

  3. Indexing helps to retrieve the data faster

  4. All of the above

Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

In Proc SQL simple index, the index name defaults to the column name but isn't required to match. Indexing significantly speeds up data retrieval by creating lookup structures. Values don't need to be pre-sorted for indexing to work.