Physical Design   «Prev  Next»

Disadvantages of Indexing - Quiz

The answers you selected are indicated below, along with the text that explains the correct answers.
 

1. When you index a field, which operation on that field occurs more quickly?
Please select the best answer.
  A. Updates
  B. Searches
  C. Deletes
  D. Inserts

2. An RDBMS automatically creates an index for what field(s) in a table?
Please select the best answer.
  A. Primary key fields
  B. Foreign key fields
  C. Non-key fields
  D. Candidate key fields

3. When would you usually choose not to index a field?
Please select all the correct answers.
  A. When the field is used to link a table to another table
  B. When the field is not used to link a table to another table
  C. When the field is not part of the primary key
  D. When the field is part of the primary key