Multiple choice technology databases

On which data type indexes can not be created.

  1. NUMBER

  2. LONG

  3. VARCHAR2

  4. RAW
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle, LONG is a legacy datatype with restrictions - you cannot create indexes on LONG columns. NUMBER, VARCHAR2, and RAW all support indexing. LONG has been deprecated in favor of CLOB. This is a well-known limitation of the LONG datatype.

Keep practicing — related questions