Multiple choice technology programming languages

Can Long/Long RAW be clustered?

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle database, LONG and LONG RAW data types cannot be used in clustered tables or indexes. Clustered tables require that the clustering key columns be stored together, but LONG/LONG RAW columns have storage restrictions and cannot be part of a cluster. These legacy data types have many limitations in Oracle - modern code should use LOB data types (CLOB, BLOB) instead.

AI explanation

Oracle does not allow LONG or LONG RAW columns to be part of a cluster — clustered tables require the clustering (key) columns to support Oracle's cluster storage mechanism, and LONG/LONG RAW's variable, unindexable, streaming storage model is incompatible with that. This is one of several well-known LONG/LONG RAW restrictions (also can't be indexed, used in WHERE clauses, or replicated in many ways), so the statement "Can Long/Long RAW be clustered?" is False.

Keep practicing — related questions