Physical Design   «Prev  Next»

Database Clustering Disadvantage - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 

1. You should cluster data based on the corresponding values of which fields?
Please select the best answer.
  A. Primary key and candidate key fields
  B. Primary key and foreign key fields
  C. Foreign key fields in both tables
  D. Primary key fields in both tables

2. Clustering data speeds up what type of operation?
Please select the best answer.
  A. Updates
  B. Inserts
  C. Searches
  D. Joins

3. Clustering data slows down what kinds of operations?
Please select all the correct answers.
  A. Updates
  B. Inserts
  C. Searches
  D. Joins