Multiple choice

Which of the following types of storage structures can be used to create three tables that will be frequently joined based on similar key column values?

  1. LOB

  2. Hash cluster

  3. Nested table

  4. Index cluster

  5. _

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In an indexed cluster, Oracle stores together rows having the same cluster key value. Each distinct cluster key value is stored only once in each data block, regardless of the number of tables and rows in which it occurs.