Clustering Tables   «Prev  Next»

Hash Clusters and Droppings Clusters - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which of the following is not a difference between a standard cluster and a hash cluster?
Please select the best answer.
  A. The standard cluster includes the cluster key value in the data blocks.
  B. A hash cluster preallocates all the space for the cluster when the cluster is created, while a standard cluster does not.
  C. The index for a standard cluster contains an entry for each row, while the index for the hash cluster contains a single entry for each value of the hash cluster.
  D. A hash cluster must have only numeric values in its cluster key, while a standard cluster does not.

2. How does Oracle determine how much space to allocate for a hash cluster?
Please select the best answer.
  A. Multiplies the SIZE of the cluster by the number of unique values for the cluster key
  B. Multiplies the SIZE of the cluster by the number of unique values that the hash function can return
  C. Multiplies the SIZE of the cluster by the value of the HASHKEYS parameter
  D. It doesn't. It dynamically allocates space for the cluster.

3. Which of the following syntax options for dropping a cluster are required in which circumstances? Please select all the correct answers.
  A. The DROP CLUSTER keywords, in all circumstances
  B. The CASCADE CONSTRAINTS keywords, if the cluster contains tables
  C. The INCLUDING TABLES keywords, in all circumstances
  D. The INCLUDING TABLES keywords, if the cluster contains tables