Multiple choice technology programming languages

In Proc SQL, Index can be created on tables and views. State whether the statement is true or false. Also classify the index types in Proc SQL?

  1. True, Simple and Complex

  2. False, Simple and Composite

  3. True, Simple and Composite

  4. False, Simple and Complex
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

PROC SQL cannot create indexes on views because views are virtual tables, not physical data storage. Indexes can only be created on physical tables. PROC SQL supports two index types: Simple (single column) and Composite (multiple columns).

AI explanation

In PROC SQL, indexes can only be created on tables, not on views — a view is just a stored query and has no physical storage of its own to index. The valid PROC SQL index types are Simple (single-column) and Composite (multi-column) indexes; 'Complex' is not a recognized PROC SQL index category, which is why the correct classification is Simple and Composite.

Keep practicing — related questions