Multiple choice technology databases

What is a cluster Key

  1. The related columns of the tables are called the cluster key. The cluster key is indexed using a cluster index and its value is stored only once for multiple tables in the cluster.

  2. The related columns of the tables are called the cluster key. The cluster key is indexed using a b+ tree index and its value is stored only once for multiple tables in the cluster.

  3. The related columns of the tables are called the cluster key. The cluster key is indexed using a bitmap index and its value is stored only once for multiple tables in the cluster.

  4. The related columns of the tables are called the cluster key. The cluster key is indexed using a range index and its value is stored only once for multiple tables in the cluster.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In an Oracle table cluster, the cluster key consists of the related columns shared by the clustered tables. This key is indexed using a cluster index, allowing rows with the same key value to be stored together physically, reducing storage redundancy. B-tree, bitmap, or range indexes are not used for cluster keys.

Keep practicing — related questions