RelationalDBDesign RelationalDBDesign



Clustering Tables   «Prev  Next»

Creating Cluster Key - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. Which of the following steps is not necessary to create a working cluster?
Please select the best answer.
  A. Create the cluster
  B. Create the tables that will be in the cluster
  C. Create the cluster index
  D. Create a foreign key constraint between the tables in the cluster

2. If you drop a cluster index, what is the effect on accessing the data in the cluster?
Please select the best answer.
  A. Data access for the cluster will be slower
  B. Data access for the cluster will be faster
  C. Data access for the cluster will not be possible
  D. Data access for the cluster will not be affected

3. Which types of data might be appropriate for use in a cluster?
Please select all the correct answers.
  A. All data is appropriate for a cluster
  B. Tables with a master-detail relationship
  C. Tables where the cluster key is frequently updated
  D. Data usually retrieved by selecting a value from a cluster key