Multiple choice technology databases

You may use the CREATE INDEX statement to create an index on (choose all that apply):

  1. This is hard to determine

  2. One or more scalar typed object attributes of a cluster

  3. One or more columns of a table

  4. A nested table storage table
Reveal answer Fill a bubble to check yourself
B,C,D Correct answer
Explanation

CREATE INDEX in Oracle works on table columns, cluster object attributes, and nested table storage tables. Indexes organize data for faster lookups on these structures.

Keep practicing — related questions